CentOS Stream is rolling between minor releases, not between major releases. So e.g. a CentOS Stream 8 system won't roll over to CentOS Stream 9.

I do believe they're working on making major version upgrades easier, but they would still not be automatic.

None of the packages should be "unstable" barring any major bugs, (or maybe proprietary kernel modules that expect a very specific kernel version).