The baseline is that Rocky has what RHEL has. Those are described in Red Hat Enterprise Linux Application Streams Life Cycle | Red Hat Customer Portal
That is, RHEL 10 has MariaDB “10.11” as Full Life Application Stream. That is, supported to 2035.
Likewise, RHEL 9 has MariaDB “10.5” supported to 2032.
In addition, RHEL 9 has MariaDB “10.11” Application Stream, supported to 2028.
It is possible that RHEL 9 will get a new MariaDB Application Stream to replace the “10.11”, but the “10.5” will remain available the whole RHEL 9 lifetime.
Similarly, RHEL 10 may get a newer version of MariaDB as Application Stream later.
What is provided in RHEL is supported by Red Hat, with backported (security) fixes.
The idea of Enterprise Linux is that you can set up a MariaDB (nominally 10.11) server now and use it until 2035.
The “ordinary dnf install” is the intended way to manage software in Rocky.
Use of some script smells like “source install”, which one should not do as it can mess up the package management. (Exception: source install as regular user to outside of system directories should be safe.)
The alternative is to not use what RHEL/Rocky has. To use third-party packages/applications.
Those are not supported by Red Hat nor Rocky. The builds and support must come from those
third parties.
The mariadb.org is a “third party” in this context. If you want them to build packages for rhel10/rocky10, then you must contact them about it.
Yes, the el10 is still very new.