That's not really what CentOS Stream is, though. CentOS Stream is a major-version stable release, just like CentOS Linux was.
But unlike CentOS Linux, Stream is supported all year long. CentOS Linux was unsupported for 2-3 months out of the year, every year. That's not a good security posture.
It is very very likely that the people who've told you about Stream have also never used it. Since I do, I can say: It's good! Much better than the old process.