Every season of PIC has ended up being a narrative embarrassment by the end, with these ridiculously convoluted plots that you have to have a lot of mental fiber and effort to give a shit about.
No matter how much work the actors, set designers, music composition regurgitator, and directors whose name rhymes with rakes put into it, the ball gets dropped by writing at the end. It's the same problem Discovery had but writ larger. I wanted to like this show at the beginning of every season, and it gave a lot of fun stuff for the fans, but they always went for the highest difficulty tricks they were completely ill equipped with talent to perform.
And it did not have to be that way. All viewers wanted for season 3 was a decent return of the cast, a good adventure. They didn't need to revisit all the big bad guys of the past, connect every dot, get Raffi on drugs again, (and seeing as Picard showrunners love killing off the young, lets just assume that Geordi will be getting a folded up UFP flag or two by ep 10.). There didn't need to be yet another Galaxy Ending Crisis of Totally Devastating Consequences That Nobody Could Foresee.
For people who liked it, I'm glad you liked it. It's a better legacy for the TNG cast than Nemesis but that's not really jumping over a high bar. In 10 years this series will be forgotten except for the fans, and even the fans will have mostly moved on.