I may be in the minority on this but I have enjoyed this season much more than Mandalorian which also ended this week. This could be the enjoyment of the nostalgia, or it could be the writing.
The final episode culminates in a battle with the arch enemy of the federation, the Borg. As a couple of my friends have lamented, Picard doesnt seem like the Picard of TNG (Star trek, the next generation), because of either his age or the show's writing. However at the beginning of the show he answers with an astounding "What began over 35 years ago, ends tonight!" The solution is to sever the connection from the borg collective to the rest of the fleet. The underlying conflict is if Jack Crusher dies as a result of this.
What Star Trek Picard brings us more than the old Star TreK: TNG is character development and the acting is more subtle, especially from Patrick Stewart but still powerful. The facial expressions from Jonathan Frakes (Will Riker) during this season would have been comical on his younger 30 year old self. The love between Deanna and Riker would have been too cheesy in the old, young versions. But with the older versions of Deanna and Riker, they appear as a quaint happy old couple, like your favorite set of grandparents.
Beverly Crusher is an ace gunman on a starship.
Data has a "gut" and emotions. He hates the borg. He has obtained what he has always set out to gain, human emotion.
The same question that has persisted since Spock has originally phrased it is posed again.
Do the needs of the many outweight the needs of the few?
However it is intersected with the joy of family which ultimately helps the humans defeat the Borg. We are rewarded with more fanfare at the end with everyone laughing in a circular camera shot and we have a good sense of closure as the actors, and the characters they play, gracefully age into timelessness.
I was very sad to see this show end and the fanfare and reference to the old Star Trek: TNG was well done. However, the promise of a new spin off is extremely exciting.