Have a look at AL8.9
I've got a CentOS 7 server, and it's pretty much EOL now. So I've got to move to a new server in the next few months. I'm thinking that I'll get Rocky Linux, I like what I'm hearing about the way they are going to be managing their kernels, using upstream instead of 87 million patch levels. That vendor approach of patching the Hell out of old kernels isn't ideal either, it can have bugs and run like shit when they keep sewing arms onto that old octopus.
I moved my collection of Centos 7, RHEL7 &c machines (& VMs) to Almalinux 8.8 (now 8.9) a while ago and the migration was fairly painless. Apart from recently unsupported devices (LSI SAS HBAs mp3sas) which was fairly easily remedied, rather unremarkable.
My guess is that Alma might start offering more recent stable kernels as an optional stream.
The kernel shipped with aarch64 AL8.9 is 6.1.x which works an RPI 4 (not 5), but also works with the 6.6.x kernel (and modules etc) from Raspberry Pi OS on a RPi 5 - a Frankenkernel Debian bookworm/EL8 Chimera.
So I would imagine that within reason substituting later kernels isn't that problematic - as long as the glibc and runtime loader is compatible with the kernel, I suspect the worst you might get is an ENOSYS.
The main loss is that the hardware that RH has certified their kernel against won't be certified with a newer kernel.
Not that very different from running a EL8 application in a Podman container on an EL9 host.
Springdale (formerly Princeton) Linux offers EL8 and EL9 network install ISOs and pxe images but its not obvious to me what their upstream distro is.
Their repositories of EL compatible scientific software can be a real timesaver for the overworked BOFH. :)