Fails to install on Ubuntu 24 due to python-pymysql in mariadb_pre_req_packages

[gurudusty]

Describe the bug
When attempting to install on Ubuntu 24.04 with mariadb v10.11 there is a failure:
fatal: [dbc03]: FAILED! => {"changed": false, "msg": "No package matching 'python-pymysql' is available"}
fatal: [dbc01]: FAILED! => {"changed": false, "msg": "No package matching 'python-pymysql' is available"}
fatal: [dbc02]: FAILED! => {"changed": false, "msg": "No package matching 'python-pymysql' is available"}

This was originally reported in #212 .
I wasn't sure of the policy for attaching work to closed tickets and I finally have some time to work on this.
I can submit a PR with the additional file, however I am unable to add tests because there is not an Ubuntu 24 docker image available at:
https://hub.docker.com/r/mrlesmithjr/ubuntu/tags
Is there another image I should use or should I attach a PR without the tests?

Additional context
The failure is due to mariadb_pre_req_packages having python-pymysql, which is not available in this version.

This appears to be due to how vars files are loaded in the role, because there is no ubuntu-24.yml, it falls back to debian.yml.
My solution locally is to duplicate the ubuntu-22.yml, creating ubuntu-24.yml.