What I'm not understanding is why people need to use RHEL and would resort to free random forks of it, instead of just using CentOS Stream or Fedora that are basically the same thing, actually from RH, and 100% free. RHEL is not that special.
I'm on the fence about that. I wish people were more willing to financially support open-source development, but I've worked with dozens of customers using RHEL over the last 10 years and never seen a single one of them open a support request - on that basis I can see why people feel that the price is too high. When the options are "get gouged" or "be labelled a freeloader", the outcome is pretty obvious.
> just using CentOS Stream or Fedora
I think the rise of free alternatives (Amazon Linux) and a DevOps-style mindset (no patching, just burn it down and redeploy when updates are needed) are exactly what has motivated this squeeze - RHEL is losing relevance in a lot of places, so RH/IBM are left with fewer potential customers and so just end up squeezing them harder.
In other words you pay for not having to open support requests.
Being an open source company means that RH has a non-standard business model and should expect non-standard profits. Their business model is inevitably doomed, but rather than innovating they are going with the "lock-in and gouge" model, exactly like Oracle.
Red Hat supports 15-ish release streams at this time between RHEL7, RHEL8 and RHEL9. A lot of customers need that because validating a base system update takes months and they cannot afford not having security updates in the meanwhile.
In my opinion 99% of end users would be served well by CentOS Stream, but the strong marketing of bug-for-bug compatible distros on part of Rocky (and to be honest it's a fig leaf to pretend CIQ is not behind that) hampered the adoption of CentOS Stream and the users' perception of its stability.
How is that lock-in from Red Hat's part?
No support requests usually means everything is working. No news means good news