When open source developers make a rolling release it's a niche techie fetish but when CentOS does it suddenly it's "enterprise" it's wild what companies will pass off as "production ready" to managers.
It really depends, if you want to install things like a big oracle db, then a classical LTS distro is better. But if your instances have short/medium lifecycles and good tests in place, then a rolling distro can even be a time saver (because you migrate your scripts/confs all the time a bit, and nothing massive like from a 10yo release to the new one)
The only visible difference I can see, is that embargoed bug fixes will hit RHEL first before CentOS stream.
This apparently is very difficult for people to understand.
It's no different to enabling the bullseye-updates repository in Debian. You get the updates from the next point release early, but it never contains breaking changes.