Den of Geek has a preview of the upcoming season 3. They have lots of good things to say about it.
There are no spoilers but some general info about what to expect:
https://www.denofgeek.com/tv/star-trek-picard-season-3-next-generation-reunion/
With unabashed nostalgia and familiar Trekkie aesthetics, Star Trek: Picard Season three is the 1990s sequel series fans have been waiting for. But is this really the last ride for the TNG gang?
So what is Picard season three? A Next Generation reunion? A backdoor pilot to another Star Trek series? A 10-hour-long TNG feature film? A love letter to fans of ’90s Trek? The answer is all of these things, and something new, too. At New York Comic Con in 2022, Patrick Stewart said that the journey that concludes in season three has left him “fulfilled way beyond anything that I had imagined.” And when fans see it, they will almost certainly feel fulfilled in a way they may not have imagined, either.
There are no spoilers but some general info about what to expect:
https://www.denofgeek.com/tv/star-trek-picard-season-3-next-generation-reunion/