IMHO the only thing that is irritating about giving Picard a tragic past is it means every one of the main characters this season has a tragic past.
Picard already had a tragic past. This season simply heaps a childhood tragedy on top of what we already knew.
That said, I agree that it's a thin premise on which to build an entire season. I mean, we're going into the finale still hazy on how Picard's childhood tragedy has anything at all to do with the central plot of Q snatching a bunch of people out of the moment of their deaths and into an altered timeline, which they then went back in time to try to set straight.
The longer the season goes on, the more certain I am that the most interesting stories this show had to tell all happened off-screen between seasons. It's disappointing because 2.01 was simply brimming with potential - and was also, not at all coincidentally, the only episode this season that was actually
about the characters we'd come to know through season one. It was the only episode of the season that picked up each one of their stories and moved them forward, caught us up with what happened next and where they are now, and it did that in interesting and engaging ways that left us wanting more. Picard had found his retirement niche as Chancellor of the Academy - so perfect, a whole new generation of cadets to inspire. Elnor as the first Romulan cadet in Starfleet, and not even your standard Romulan either, but one raised by the Qowat Milat - there's a whole wealth of story potential right there. Raffi and Rios back in Starfleet - I immediately had so many questions around how that came about, whether the decision to go back was difficult or easy to make for either of them, whether or not they have any regrets, what kind of challenges they'd have faced after so many years out in the cold, were there whispers and rumours behind their backs about the circumstances of their respective discharges and reinstatement, etc. From what little we saw of him commanding the Stargazer, Rios has a laid-back style of captaincy that's all his own, he seemed to have a strong rapport with his new crew, but surely after 10 years out in the cold living alone with only the holos for company, that must have been a huge adjustment to make. Soji and Agnes were off on their diplomatic tour, Agnes having been through the legal process for the murder of Maddox in the interim - not to mention her breakup with Rios. Seven as captain of La Sirena, living alone with the merged Rios holos - from what we saw, she's clearly formed a strong friendship with Rios, having met and formed a rapport in season one, so is living with a holo based on him more or less weird because of that friendship with the original? Then there's the Seven-Raffi relationship, which had progressed off-screen but they are struggling to make work, given their very different career paths.I mean, it was all really interesting stuff - there's a whole season's worth of character arcs right there, ripe for the exploration..
But then the show dropped every single one of those character stories, except for the halting Seven/Raffi relationship, in favour of having the characters trail around after a plot that had nothing to do with any of them all season. Soji got left behind, apparently because the storyline the writers had fixed on might have been harder to pull off with her around, so rather than write around that problem they just dropped the character. Elnor was killed off early in episode three and has had a couple of hallucination cameos and one brief stint as a holo since. Rios has spent the whole season isolated from the rest of the cast in highly generic sub-plots entirely unrelated to anything we already knew about him. And his breakup with Agnes seems to have been designed purely to facilitate her story arc of being vulnerable to the Borg Queen's manipulations and ending up being assimilated - which is a hell of a depressing ending for the character, even if she does transform the Borg. The Agnes we knew from season one is effectively dead at this point. Rios is looking more and more likely to remain behind in 2024 to face the horrors of World War III, never mind the promisingly rejuvenated career he left behind in the future and seemed so happy to have reclaimed.
It just all feels so horribly wasteful. They all had so much potential.