Strange New Worlds is a proper Star Trek.
Like they Trek to planets, solve a problem, and then the Enterprise goes to the next thing.
There are season long character arcs (M’Benga in particular made me cry a lot) but very few episodes end unresolved. And honestly, though there are teases for exciting things to come, I’m satisfied with this finale as a finale. It really wraps up Pike’s arc gloriously and shows an unexpected and thoroughly exciting alternate future.
If it’s been a while since you’ve seen the Original Series, the most important episodes that SNW calls forward to are The Menagerie, Arena, Amok Time, and Balance of Terror. Rewatch those before going into this.