Loveable goofs and misfits struggling against the odds to live up to their ideals are relatable, and that future can actually be aspired to. A future which requires humans to be paragons of virtue that have evolved beyond greed, vice and want, in a universe of infinite free energy and abundance, is unattainable. Neither human nature nor the laws of physics can bend that far.
Also the new Star Trek series are incredibly popular, even among many fans of old Trek, many of whom seem to be able to reconcile it with the franchise's espoused values. I guess it doesn't work for you, but you seem to be in a minority among the fanbase in that regard.
[1] https://www.imdb.com/list/ls090972183/?sort=user_rating,desc...
But if that's the game you want to play, here are rankings by Rotten Tomatoes[0] that say otherwise.
[0]https://editorial.rottentomatoes.com/guide/star-trek-tv-by-t...
I get how this is hard to understand for today's young people, who did not grow up with the old shows. We had a whole generation growing up with a future worth working towards and aspiring to. I feel really sorry you didn't get something similar.
But that's weird because they're a completely different genre. They're closer to Star Wars (the one dumb people liked, cuz that's where the $$$ is) than Star Trek.
Give strange new worlds a shot you won't regret it.
Nothing comparable to the older stuff until SNW - and Anson Mount in particular is very good. Oh, and The Orville is better ST than much recent ST ever was.
The Kelvin timeline films have this problem, especially the first two; the third, while definitely not the classic trek series feel, felt more like a Trek movie.
The newer series (excl. prodigy, which I simply haven’t watched) have variable quality (SNW, IMO, is the strongest Trek series since DS9 and the most classic Trek feel since TNG, Discovery was up and down but overall no worse than Enterprise, Picard was good, but more like 3 long Trek movies than classic series Trek), but I wouldn't describe any of them feeling more like Star Wars.