I'm sure it'll be fun and I'm always glad to have more trek.
Two things concern me, first every person we've met previously from section 31 has been an asshole. Intentional writing to make them them an organization working against the ideals of the federation. Will that make it harder for me to like the characters or their missions? I am unsure if I want to relate better to them.
The second is that universe ending stuff has little emotional impact on me, it's unimaginable to me especially with the CGI required to visualize it. Episodes always hits me harder when it's a planet, a species, a special person or some mystery to be discovered.
I agree the end of a series can feel a little draining as the stories conclude. I get that way with books too.
Lots of rewatches of the trek series, and I do skip ones that are boring to me, sometimes I just follow main story arc with ent and voy, but there are some really good bottle episodes that I miss that way.
If it feels like work to watch an episode, then I skip it. Sometimes it's the topic, or my mood, or life.
Enjoy tng again!