I very much enjoyed the start but steadily lost interest.

There's some good stuff in Discovery all the way through, don't get me wrong. But they kind of flipped the script in a way I did not appreciate.

Most of classic Trek showed us a future with a largely functional society, mostly full of good people who were ready and willing to deal with occasional corruption.

Lots of newer Trek, and especially Discovery, showed us a future where society is largely dysfunctional and corruption is the norm. Almost everyone in the series who isn't a main character (plus a couple who are) is a piece of shit. Even the "good guys" frequently encourage or at least tolerate clearly evil behavior as long as it serves their ends. But it's okay because...friendship I guess?!?

Their heart is in the right place but the writing is generally bad. I think this generation of writers is incapable of imagining a better world, which, sure, is understandable, given how thoroughly corrupt our current society is. But it's deeply depressing. It lacks soul.

SNW is better in this regard. But you'll probably want to watch season 1 of Discovery first since there's some crossover.