The situation with RHEL right now is pretty weird and complicated.
But here's my understanding of it:
1. RHEL is the most stable version. CentOS Stream is the upstream version, Fedora is more on the bleeding edge.
2. Fedora and COSS both retain their open source status. RHEL? Not anymore.
3. Alma and Rocky are screwed, and will either need to rebase on COSS (upstream of RHEL) or do some weird rebasing to Debian or something else. This will affect a lot of servers using free forks of RHEL.