Just rewatched "Tapestry". Conceptually it's very cool, everyone gives a good performance, but it's not really clear what the takeaway is. Okay, so Picard had to be a brash impulsive young man to learn the lessons he needed to learn to become the man he is today. That's reasonable. But Picard didn't ask Q to go back and relive the event and do it differently; Q asked him. There's no evidence Picard didn't realize that his formative years were important to begin with. Q tells him he has to go back to his youth and change this event or he will die. So he does. Then Q says "Hahaha you wanted to change that event? Look how shit your life would be". Who's learning the lesson? What is the lesson??
Also, almost nothing of what happens really makes sense. I get that his buddy is a hothead trying to stir up shit with the Naussican. That makes sense. But Picard tries to stop him by saying "It's not worth it" "Nah, don't worry about it" "We might get in trouble". How about make it clear? "I saw that Naussican sharpening his knife, he's literally going to stab you to death if you fuck with him." How about "They have disruptors" How about "That guy's a known contract killer". Picard doesn't even attempt to make the case for why they shouldn't hustle the Naussican. No wonder his friend felt he didn't have his back.
His female friend spends the first half of the episode hitting on him like a hammer. She obviously has feelings for him. So, having changed history a little, he decides to sleep with her. The morning after she says "Well even though I initiated this we aren't friends anymore byyyyyyye". The scene doesn't really make any sense. It feels like something was cut out. Which it was; according to production notes for the episode from Captains Logs, the actress originally had a monologue where she talked about her self-doubt and how she admired Picard and a bunch of other stuff. The actress herself is happy it was cut because the tone was whiny, but I think as-is the scene doesn't play very well.
We flash forward to the alternate future. Picard is a Lieutenant JG on the Enterprise. He's instantly disappointed. And no doubt that's a real disappointment; if you could teleport Obama to an alternate world where he's still a State Senator, he'd probably be crushed. But the show becomes unusually mean-spirited about it way too quickly. Picard asks Riker and Troi to evaluate alterna-him as an officer, and they say he's good but... lacks direction and focus and they don't see him moving up the ranks. Frankly, Lieutenant JG on the flagship of the Federation is not a bad gig. I see why Picard would say it was. I get why he's crushed. But it's weird for Riker and Troi to treat him like a lifer with no chance of accomplishing anything when he's already elite among his peers. It's also weird that we he says he wants to prove himself worthy of more, their immediate reaction is to tell him straight up "I doubt it" and crush his dreams.
Definitely the episode is more than the sum of its parts, it's pretty resonant, it's a great episode like I remember. But I'm not sure it succeeds on the level that something like The Inner Light or Chain of Command II does. The original draft of the script was full blown "this was your life" / "a christmas carol" where Q guided Picard through major moments in his life. There was a scene on the Stargazer with Jack Crusher. In script revisions, Michael Piller argued that it was senseless to just relive these moments, and they should try to incorporate a moral element. Then they narrowed down to the Naussican stabbing. But I'm not sure they got the moral--what's the moral? What Picard already knew, that he was who he was because of the sum of choices he made in his life? We know this. When he tells Wesley about his misbehaving youth in earlier episodes, he recognizes that it made him who he was. When he talks to Boothby, he seems to be able to reflect on who he is. Is this guy who really needs a self-confidence boost? *shrugs*