Do you have any idea what differentiates Star Trek from the countless other sci-fi shows? I'd like to hear what's so special and so important about the franchise, that it can't try something different.
Star Wars is space adventure. Space and different planets are a backdrop for an adventure story involving magical knights. Firefly is similar. Things like Battlestar Galactica or The Expanse are dystopian stories with space as an integral part of that future.
What makes (made?) Trek unique was that it was portrayed as the future of our species, showing a (violent, genocidal) path from today to the Federation, but this ultimate future wasn't a dark dystopian one. Space exploration is integral to Trek, like in the dystopian stories, but it was used to show a better version of humanity realising its place in the galaxy.
The drama in every space sci-fi I can think of comes from a galactic conflict with the protagonists on one side. In Trek you do have galatic adversaries (Klingons in TOS, Romulans and Cardassians in TNG), but it's a cold war and diret conflict only flares up in few episodes. And even in eps where they there are battles, there is something else going on - the first appearnce of Romulans in TOS is submarine warfare in space, but has a bit about racism towards Vulcans, the double header with the Cardassians in TNG was about the crew learning to adapt to a strict new captain, and Picard reaching his limits under torture, than about any battle. War or past wars are used to do a story about the main characters (Duet in DS9 is a classic, there are many more like it in DS9 and some in Voyager and TNG), but the main story isn't about the war itself.
The only extended war storyline was the Dominion war in DS9, but this was consciously done as a break from utopian Trek (the multiple Section 31 eps, In the Pale Moonlight, AR-558 all have characters explicitly dealing with Federation ideals breaking down during war).
For the rest of it, without the crutch of war to fall back on, individual eps had to be about diplomacy (usually someone trying to sabotage diplomacy), dealing with other races, how/whether humans have really changed, or character conflicts. It could be awful and cheesy, or it could be great and unique. Darmok and The Inner Light are beautiful eps I can't imagine on any other shows.
I saw S1 of Discovery and the writers didn't seem to have any idea what had come before it. It got the sounds right, some of the design, the names of the aliens, but the Federation stuff was irrelevant or just stray inexplicable lines or choices.
I haven't seen Picard, and my initial reaction was the exact opposite of what you'd think - I did NOT want Picard back on the screen. The last ep of TNG was absolutely brilliant and a great sendoff for both him and the show. I was also scared that there were no more stories in this genre- I like Orville, a blatant Trek ripoff, but almost every plot point can be traced back to an old Trek ep. But the reviews for Picard seem to be good, so I'll subscribe later.