Just a heads up if you do try it, I mean the original not Catalyst. The sequel constantly kills that flow state with all the annoying intrusions you'll see from other AAA open world games. It's not the worst game ever, I did finish it, but it was the last time I bought something on release.
The original is just a short collection of levels. It's extremely minimalist. The only diversions from the flow is a simple story linking them and a handful of hidden collectibles.
You're kind of right. Discovery S1 was trying to be a dark, prestige drama. It felt a lot more like BSG than Trek. I haven't watched it since it premiered but I don't remember hating it, though I didn't love it either.
They fired their show runner pretty early, so there is another tone shift from S2 onward. The tone becomes a lot more like the new-Trek movies, and later much more like Strange New Worlds. Take a look at screenshots from Season 4 compared to Season 1 to see just how much it shifted stylistically.
The real issue isn't aesthetic or tonal, it's that the writing is excruciating.