I have been running NC on debian for years, upgrading all the way from somewhere below 20 to currently 26 on the stable channel. The only thing that ever broke anything for me is switching php7.4 to 8.1, and that only because I’m a bit of a noob at php things and didn’t properly install all relevant packages on my first try. So I would offer that as another anecdote.
I don’t see that happening anytime soon, because it will be very hard to convince literally everyone to be ok with what they need and pass on what they want.