Is Star Trek in a good place right now? Well, on the one hand - Yes. There are numerous shows currently filming, with big budgets and decent actors. Discovery must be a success because they are making more of it and there are spin offs. One thing the new shows do very well is that they have an inclusive and diverse cast, finally representing a future that is for all people.
But for myself, I see how split the fandom has become. To be fair, one could argue that this was always the case, but it's remarkable to me the vitriol against Discovery, Picard and Lower Decks that is out there. It seems to me at least, that a lot of people dislike the new shows. Not just fans either, but the people who worked on the older shows, people like Doug Drexler (whose essay on why canon matters makes for interesting reading), The Okudas and various others that I follow on social media.
Many years ago (2012), I wrote a blog post on why I personally liked Star Trek. If you're interested, head over here:
https://ryesofthegeek.wordpress.com/tag/star-trek-the-next-generation/
I would argue that Star Trek is not in a good place, for me personally and for its survival in the long term. I liked Star Trek for it's optimistic viewpoint, whereas I find that Discovery and Picard are a bit grim-dark, with morally challenged humans, often engaging in acts of brutality (the "yum yum" line of dialog might just be the worst line ever in all of Star Trek). As for Empress Georgiou, I cannot fathom how Starfleet would let her loose or trust her in any way, nor do I like the way that the Characters seem to find love for someone who is essentially a genocidal maniac.
Much of DSC and Picard depict dystopian elements in the future, which is the antithesis of Star Trek (in my opinion). Then there is the tone, which is much more brutal, we have decapitations, eye gouging and our heroes often act in emotional and reactive ways, rather in measured and rational ways. Bizzarrely, this is mainly true of Burnham, who starts off as a detached and rational character as a result of her Vulcan upbringing but who becomes a whispe. The depiction of humans in the future is far more reflective of humanity as it is now, rather than what it could become.
I liked Star Trek for its attempts (albeit not always successful - I'm looking at you Threshold and Genesis!) to be scientifically accurate. But again, I find DSC especially fails in this regard, with nonsense like the magic mushroom drive, and the Red Angel Suit. Hell, don't get me started on impervious bulkheads or cavernous turbolifts. The universe does not feel real and/or plausible.
I liked Star Trek because the answer to problems was rarely a giant space battle, or killing - Burnham literally goes on a killing spree in the first episode of season 3. The 'baddies' in DSC and Picard are terrible - almost cartoon characters, with dreadful over the top dialog and acting. Picard didn't shoot first and ask questions later and The Enterprise was never a warship. TOS and TNG especially showed scientist explorers in space and we visited strange new Worlds.
TOS became a phenomenon in the 70's when people needed a positive view of the future. TNG then became a mainstream success in it's own right, DS9 and Voyager were never as popular and I think that most people outside of fandom have probably forgotten about them. Enterprise was, obviously, a faliure in the sense that hardly anyone watched it.
Why is The Mandalorian such a huge success? I'd argue that its because it harkens back to what made A New Hope such a monumental hit. Star Trek's creators could and should look back to what made Star Trek great and try to incorporate some of those elements. The Mandalorian didn't redesign The Star Wars universe to make it look more contemporary, no, they purposely wanted to embrace the rich history and fit in with the established continuity. For Star Trek to really engage in the cultural landscape like The Mandalorian, it needs a bit of self examination.
Is Discovery a terrible show? I don't think so. But it could be Star Wars, or any other generic Sci-Fi actioneer. To me anyway, what made Star Trek special isn't present.
"Picard" might just be the most half assed show that I've ever watched, it's telling that Nepenthe is the episode that most people seemed to enjoy as it is the one episode that has some humanity in it. The series subverted my expectations in the worst way possible. Dark, with a nonsensical explanation for Data's reincarnation and then his subsequent suicide and with a plot that seemed to have ripped off Mass Effect. Even the production value looked poor, with an aged Brent Spiner cosplaying as Data, with what must be one of the worst wigs of all time, not to mention a cut and paste fleet or the copious use of the DSC shuttlecraft. As for Lower Decks, I guess that I just don't get the humour, I gave up after episode 3.
Anyway, that's got that off my chest. And it's just one disappointed fans subjective opinion.