Certain people make the mistake of assuming the franchise is in trouble based on whether or not they like a series. I base it on the bottom line. Are they making more series or less? Are films coming out more often or less? I put my opinion of said series and films aside.
From 1994-1999, they had two series at the same time and a new movie every two years. Then from 1999-2005, they were down to one series and a new movie took four years. During the early-2000s, Star Trek was in trouble. It couldn't survive as it was. Since 2017 is a different story. The number of series expanded from one to five. Apparently it can survive as it is. At least on Streaming TV. The movies, on the other hand, if you want to say the movies are in trouble, then I might agree. They're going nowhere. But on the TV end, it's not like that.
When Paramount+ starts making less Star Trek series instead of more, that's when I'll agree that Star Trek on TV is in trouble and the series are in danger of cancellation (DSC or otherwise). But it's not going to have anything to do with what the Fandom Menace says. If they're ever right, it's ONLY going to be because even a broken clock is right twice a day. That's it. They won't be right because they actually have a point, they'll be right because of dumb luck.
Right now, DSC looks like it has a bright future ahead of it. When it ends, it'll end on its own terms.