OMG wow, what an episode! 10/10. I know the showrunners never intended the comparison, but that was a shot across the bow of Discovery. This show is just on a whole other level.
Besides the in media res action scene (which is missing several of the action scenes in the exploding turbolift and corridor shown in the preview, BTW), the first half of the episode is fairly standard "where are they now" orientation, set about a year and a half after the events of the first season. Regrettably, one misstep (unless the actor was not available for reshoots) is that Picard's live-in housekeeper / former Tal Shiar operative Zhaban died offscreen to make room for the tease of a Picard / Laris relationship.
They address Picard's synthetic nature and his death / mortality multiple times and don't shy away from it, with new more confident and wisecracking (and better written) Jarati even saying "You look absolutely positronic!" They address Jurati's murder of her boyfriend Bruce Maddox and that she was found not-guilty by reason of alien induced temporary insanity. They address what's going on with the Borg right now a couple decades after being decimated by Voyager. They address Guinan's and Q's aging: El Aurian's can adjust their speed of aging to blend in with the species they are living among, and Q appeared CGI de-aged at first and then once he saw Picard, he aged himself up to match. They address what the androids and their "ambassador" to the Federation Soji are up to and that the synth ban has been lifted. They even address the source of Picard's British accent and his hesitancy in finding lasting relationships and around children, which is due to his father being abusive to his mother, something Patrick Stewart experience himself, so it's particularly close to home for him (and me).
You'd think that addressing all these things would bog the episode down in boring minutiae, but it's handled with a brevity that's refreshing and never takes away from the progression of the story, only complements it.
As much as I am a Picard / Beverly shipper, I really hope Picard can overcome his reticence to form a lasting relationship again and get together with Laris. She looks thirty years his junior but given she's a Romulan she could be a century older than him for all we know and he's the youngin'. She's clearly devoted to him and his care and he to hers regardless, but she wants their to be something more and Picard is holding back because of his father's abuse of his mother and their separation, plus Picard's sense of duty and wanderlust. They make a good couple though so I hope he changes his mind. Since it's the 25th century now the marriage to Beverly and divorce from the Q "All Good Things..." reality could have already happened, as many other developments did.
Helping Picard with his relationship woes is his trusted advisor Guinan, now offering real alcohol from a back-alley speakeasy in downtown Los Angeles, which I'm sure will come into play during the time travel to 2024 LA later on, although Guinan must have left it in someone else's hands for quite some time when she returned home to El Auria before it was destroyed by the Borg. It feels like old home seeing Picard and Guinan together again sharing a chat.
I'm really digging fun-loving, confident, drunk off her ass Jerati. She's not entirely stable, and she pushes boundaries, but she gets the job done when the time comes and her character is much more interesting to watch. I'm not entirely clear on what her role is, at first she's hanging out with Soji at the Federation party for reintroducing synths into Federation society, getting flirted with by a Deltan while she's "half in the bag" (her words). Next she's on Rios' Stargazer as some kind of civilian consultant, but clearly new in the role as the crew don't know how to react around her, so maybe just for that mission.
Rios, of course, has command of the Stargazer but seems to have a little trouble adjusting from the life of a pilot of fortune back to Starfleet formality, having a rapid fire set of exchanges with his crew and chomping on his signature cigar the whole time. I truly expected the cliche scene of the cigar hanging limply from his mouth as he stared mouth agape at the event of later in the episode, but they avoided it. But I'm very happy to see him back in Starfleet again and with Picard's legacy starship to command.
Seven of Nine is caretaker of the La Sirena, though there's a bit of a Lando/Han "What did you do to my ship? Your ship?" exchange between Rios and Seven when he sees the battle damage from an attack by thieves trying to steal the medical supplies she was transporting. Seven and Rafi are together but it's a long distance relationship with Rafi being back on Earth and it sounds like it's on shaky grounds.
Rafi, as mentioned, is an instructor at Starfleet Academy and has kicked her habit and taken cadet Elnor under her wing as a sort of adoptive son since the relationship with her own son is so strained. She's still somewhat shaky and questioning herself, but has definitely come a long way since the depths of her addiction and is even closer to Picard than before.
Elnor, as the first full-blooded Romulan (most likely a callback to Saavik's half-Romulan blood from the deleted scenes of TWoK, or could be someone new) is having some of the usual difficulties of Vulcanoids dealing with the clash of cultures at the Academy, but is helped along by the tutelage of Picard and Rafi.
So, the a-plot is the return of the Borg, but not like the Borg we knew before. This time they open a subspace rift and send a distress signal saying "Help us, Picard." A friendly and sane admiral (which is practically like seeing a unicorn in Trek} asked Picard to come out of semi-retirement (he's Commandant of the Academy but appears to be a civilian still going by the significance of the scene of her handing him an official Starfleet commbadge as opposed to the different one he was already wearing) and travel to the Stargazer to respond.
As soon as he does respond to their distress call, the Collective starts speaking through many voices as one and it's a genuine "Oh shit!" moment for the crew and still pretty chilling even though I knew it was coming. They have somehow managed to pull off the combination of making the Borg (even more) terrifying again while seemingly having peaceful motives and being in need of Starfleet's help. The Borg Queen beams through the Stargazers shields in seconds and she's wearing some kind of Nine Inch Nails meets Daft Punk meets Nosferatu protective suit with tiny gears within gears in the helmet, possibly as a reference to the "wheels within wheels" of the Cherubim in Ezekiel 10:10 or possibly just because it looked mechanical and complex and cool. She starts tentacle porn'ing the consoles of the Stargazer bridge, gaining control of the systems of not only the lead ship but also the entire fleet, and siphoning energy to level up to God Mode. She starts taking out everyone shooting at her en masse, but crucially, only stuns them, to Seven's surprise (who had been understandably calling for Rios and Picard to open fire as soon as it was revealed to be Borg). But since she's taking over the fleet despite them firing salvo after salvo into her asymmetrical ship, Picard orders the auto-destruct, which is the familiar Kirkian "Zero Zero Zero Destruct Zero."
The Queen's "Look Up" comment to Picard quoting his mother was surprising and chilling, though of course, she has all of his memories. But still, very effective.
The Stargazer is destroyed, but Picard winds up in his old home on a planetary shielded dark altered Earth (being bombarded by increased solar radiation) confronted by a young CGIQ, who quickly ages himself up to De Lancie's actual appearance so as to better match Picard. Picard yells "Goddamn Q!" and Q tells Jean-Luc the test from their first and last encounter never ended. And that's how the episode ends. That last twenty minutes or so was edge of your seat stuff.
I can't say enough about the writing, acting, visual effects, music, and worldbuilding in the episode. We get the typical future San Francisco of course, but we also get a future LA which isn't all that different apart from some new buildings and the shuttles flittering around everywhere. They heard the complaints of fans about the cut and paste all the same ship fleet from last season and included a wider variety of ships in the fleet facing the Borg, including Nebulas, Akiras, Steamrunners, Novas, Luna Class (first live action appearance) Inquiry Class, updated Excelsior, several Sovereign Classes finally making their long-awaited first TV appearance, one ship from Disco I believe, and several others. They've got the Eaglemoss CGI models and Star Trek Online to draw from, so it's good to see them using those resources instead of lazily making thirty copies of one ship.
I really liked the retooled opening sequence showing the events of the coming season (the spatial rift turning into an hourglass was neat), but the changes to the main theme weren't quite as good as Season One's version. Not bad, though.
Picard is considering retooling the Kobayashi Maru test. USS Excelsior (Rafi's and Elnor's new ship), USS Grissom, and USS Hikaru Sulu are mentioned taking on cadets. The awesome looking new Stargazer incorporates Borg tech taken from studying the Artifact cube from last season. The asymmetrical Borg ship looks like an all-black and greebly Narada / Scimitar / Borg ship from Descent Pt 1 & 2./ Kal-El's Kryptonian lifepod mashup.
The show deals with love, grief, lacking confidence and giving encouragement, recovering from trauma and loss just like Discovery does, but handles it in such a more believable, non-sappy and saccharin, non-overwrought and stretched out, effectively written way than Disco does. One of the many scenes of adult conversations would have been a twenty minute Burnham crying screed in Disco complete with hugs and a sharing circle.
Always in the back of my head is how I excited I was at the start and through most of Season One, and then they kinda shit the bed in the finale. But this was even better than the Season One premiere episode, which I loved, so I'm hoping hoping hoping they can keep a consistent flow to the storyline without too much filler and stick the landing in the end.