As the other reply said, Fedora and RHEL harbor the same problem as Ubuntu in terms of corporate backing.
They’re all as stable at it gets when it comes to linux distros; all those “server distributions”.
I guess people recommend debian because that’s what they know. It’s got the biggest community, so the most support.
Nothing against Rocky, but i wont recommend it if i’ve never used it.