This is where I will differ probably a bit strongly. The biggest thing that I do not do and sometimes struggle to understand is look to Trek for, well, anything. Be it a positive future, or inspiration, or hope. Largely because Trek is so roundly inconsistent in its presentation of humanity that such things are not always very well relatable. This isn't to criticize those who do; just an acknowledgement that the following discussion comes from a different place.The Federation of Picard is insular and reactive, and it's just hard for me to swallow. And Admiral Picard is almost unrecognizable, at least until the last 2 or 3 episodes.
Star Trek: Picard just felt off to me. I don't mind shaking things up, but there are certain characteristics I see, personality traits in Picard that just don't match up with Admiral Picard. I guess another thing is I look to Star Trek for a positive view of the future. Between Picard, and what happens to the Federation centuries later according to Discovery, things look bleak.
Yes, Picard feels very different as does the Federation. But, it is a difference that I see as completely possible given past history. For me, one of the more unbelievable aspects of TNG's future is this idea of a Federation that is constantly giving out even when hurt and wounded multiple times over. Some see that as positive; I see that as extremely unrealistic.
Same thing with Picard. He is wounded and his actions reflect that. Are they inconsistent with his core beliefs? Yes, and it creates a dissonance for him that he has to go resolve. It's a conflict that he himself was never comfortable but didn't know what else to after Starfleet basically called his bluff. It shook him, to the point that his whole career was looked back upon with a sense of despair rather than integrity. And he had to work through that.
And, for me, that working through it is an essential part of positivity. In TNG there occasional ideas of challenging these characters at their core beliefs but it was always neat and tidy and wrapped up by the end. And, for many, that's sufficient. For me, it makes for a very entertaining moment with little meat behind it. Picard is unfamiliar because he is meant to be. He is unfamiliar to himself and has to find himself again. That's a journey I find a lot of value in.
Mileage will vary.