The danger with these "very special fun episodes" is that they can be confined to being just that. But what elevated this episode is how it used the time travel/crossover conceit to foreshadow, progress and pay off SNW character arcs, including Chapel and Spock's ultimately doomed relationship (something that I've previously said could be incredibly poignant, if handled right), Number One's legacy, and the way Pike confronts his fate. I hope the musical episode does the same.
They also tied in to Tendi’s story on LD (her constant reminding to people that Orions have a culture far beyond pirating), even though we didn’t see her in Live Action.
Are Orions now the designated species for calling out how essentialized Star Trek aliens tend to be? Because we have D’vana Tendi, the somewhat obscure Ensign Harral from Discovery, and now the crew of the D’var. You can argue the last one’s just an extension of Tendi’s character arc, but still, that’s three series that have touched on this.
TBH I think TNG did this very well with the Klingons (depending on who was writing the episode, of course). Like, some Klingons were Real Klingons™ but many others only gave lip service to those ideals and were actually as sneaky and cowardly as any other race. I think a lot of Worf’s inner conflict came from realizing and processing that fact.
And on the extreme end of that was the Duras family being more like the stereotypical Romulan (and even allying with them against their own people) than a Real Klingon™. It was disgusting how they managed to keep their house throughout the series, even though they were everything a Klingon wasn’t supposed to be.
The viewer naturally sympathizes with Worf and adopts his view of Klingon culture, but remember that he was raised by humans and most of his knowledge of Klingon culture came from very early childhood and books. Imagine a human child raised by another species whose knowledge of Human culture came from fairy tales and like Arthurian stories. He’d come to earth and be outraged that everyone isn’t following some virtuous code of chivalry. A politician broke his word? DUEL TO THE DEATH! That’s Worf.
There’s also the Orion on DS9 who likes to talk big game about being a pirate, but he’s actually from Cincinnati and has never pirated anything in his life
The hidden line in the episode is that the crew knows they end up as historical icons of Starfleet and thus the line ‘I pretended to be somebody I wanted to be until finally I became that person. Or he became me.’ this applies to the crew now. It allows them to be more confident in their decisions and become the icons they are meant to be. This episode likely has one of the largest impacts on the character direction of the crew going forward.