Reports of Discovery's death after the first season were greatly exaggerated. Reports of Discovery's death after the second season were greatly exaggerated. Reports of Discovery's death after the third season were greatly exaggerated.
At this point, barring a major shift in Paramount's goals (never say never, granted) it's probable that whenever the show ends it will be on the producers' terms. Which is great! However, we as viewers have no clue when that will be. Even if we cite past commentary from Kurtzman and other influential folks, things change all the time.
When I think of TrekBBS, "long-lived" is the #1 term that pops into my mind. People have been posting here for decades. We can go back through the archives and see people asking David A. Goodman Enterprise-related questions while the show was still on the flippin' air. Unless the forums close or this thread gets deleted, we'll be able to read it a long while from now.
Here's my guess: six seasons. It falls just short of the magical Berman-era seven due to a combination of factors. For one thing, (I believe?) those six seasons will have been filmed over a somewhat longer course of time than TNG, DS9, and VOY spent filming. Critical cast members may wish to move on. For another, by 2024 or so Star Trek will presumably also have Strange New Worlds, Lower Decks, and Prodigy. (I've left Picard off the list because I'm guessing, as many are guessing, that it will end with three seasons or so under its belt due to Sir Patrick's advanced age.) Lastly, this is a seriously expensive production and the cost is only going to keep going up.
I also think the show will end with a movie-tier bang, albeit a movie that is primarily intended for Paramount+ audiences with a limited theatrical run. That will be the big, splashy finish line. But hey, now I'm getting beyond the scope of this topic.
So what say you, fellow forumites? Do you want to take a guess as to how long DISCO goes on for, leave that guess here for years, and come back when the show ends to see if you were right?
You certainly don't have to. If your thought process here is "what's the point," carry on! I just thought it might be amusing to see who was right on the money in the final telling.