I think at this point, I would contend that the two biggest creative successes of NuTrek, both in general and on their own terms, were the speculative, could-only-be-greenlit-at-the-height-of-streaming-expansion, second-tier animated properties with zero big names and minimal hype attached to them; Prodigy and Lower Decks.
(I am convinced Prodigy is going to enjoy a resurgence in a few years as people find their way back to it.)
Both of those shows were unapologetic about developing their own voices and their own ideas; Prodigy set out from the get-go as a YA adventure series that was both going to succeed where Voyager failed, and do some really weird, gonzo, cosmic shit more usually associated with something like Star Wars or even Andromeda than Star Trek. Lower Decks set out to be "what if an office comedy, like 30 Rock or Brooklyn 99, but also Star Trek?" They both COMMITTED to this, and they both succeeded at it.
For that matter... I dislike DIS, and I don't think it was ever really what you'd call good. But DIS got a lot better when they decided "no, fuck it, HARD RESET, we're going to nope the fuck out after two seasons and basically make an entirely new show." Many of the ideas they put forth were bad ones (I have real issues with the stewards of creative properties deciding ad nauseum "the most interesting thing we can do to our setting is destroy it," that's a failure state in my eyes) but the writing notably improved when the writers were no longer struggling with the constraints of "we gotta slot this into the past timeline and do Spock shit and Klingon shit and Section 31 shit and bleh."
Neither Prodigy nor Lower Decks ever really hit the high highs of the very best of classic trek; neither has a "Balance of Terror," or "Measure of a Man," or "In The Pale Moonlight." There aren't any S-rank episodes in there, and perhaps that's a failure... but there are PLENTY A-rank episodes in both of them. Hologram Janeway's speech, and her death, in "Supernova" is in my opinion the best fucking thing they ever wrote for Kate Mulgrew, delivered impeccably, animated beautifully.
Lower Decks gave us "wej'Duj," which I would place solidly as a Top 50 Trek episode, and "Empathological Fallacies," which... actually, you know what? Fuck it, I'm going to call "Empathological Fallacies" S-rank Star Trek. I will set it against ANY of the top-tier Vulcan episodes, any single one of them, "Amok Time," "Sarek," any of them, and call it as good. It's an absolutely ridiculous premise of an episode featuring horny Betazoid cougar commandos and a cannibalistic Caitian, and it delivered the most raw experience, and the most affirming uplift, of being a Vulcan in the whole fuckin' franchise, and was an especial breath of fresh air in the context of the 21st century, which has attracted a long and baffling series of writers to Trek who seem to hate Vulcans very much.
(It also gave us the best Star Trek tie-in product ever made, Warp Your Own Way, which in a just world would have won a Hugo.)
Lower Decks could pull shit like that off because it had top-caliber writers who all had a clear, unified vision for what the show was gonna be and executed. It consistently delighted us for five years and could easily have done another five. Prodigy had trouble finding an audience but it was equally unapologetic about being what it was and god, did that pay off creatively if not commercially. Both it and Prodigy also delivered on the aforementioned sense of building a universe that existed between TNG, DS9, and early VOY.
There is still life in the old girl. It can be done. It's just... man, I don't know what it is. The best theory I can come up with is that Prodigy and Lower Decks pulled a DS9; DS9 famously got a lot of creative freedom because Rick Berman wasn't paying attention to it, having already checked out and moved on to VOY. Maybe Kurtzman et. al. weren't paying attention to the weird little animated shows and lavishing all their attention on the live-action stuff, leaving them to flower away from his baleful gaze? It's as good as theory as any.