The Python Package Index (PyPI) is allowing you to download and install Connector/Python v. 1.1.1 as if it were not a pre-release version even though it appears to have a Developer Status of "3 - Alpha". (https://pypi.org/project/mariadb/)
The result of running
$ pip3 install mariadb
attempts to install MariaDB Connector/Python v. 1.1.1.
However, there is a requirement for Connector/C v.3.2.4+ before Connector/Python can be installed. Otherwise, Connector/Python v.1.0.7 will be installed.
Because I was using macOS I attempted to update Connector/C to v.3.2.4, but from Homebrew this is not possible as the current stable version is v.3.2.3 (https://formulae.brew.sh/formula/mariadb-connector-c).
The workaround I found to get the Connector/C v.3.2.4 bits on my machine was to install the latest MariaDB Server 10.6 (via Homebrew), which includes Connector/C v.3.2.4. (https://formulae.brew.sh/formula/mariadb)
Though I was able to get things to work in the end it's still a little unclear to me what our official position is on C/C and C/P support is on MacOS considering that both are available for download and installation (via Homebrew and PyPI). I just want to make sure I am helping to manage external (developer) expectations in any content that I create.