"Ruin" is not a verb that happens in degrees. You're no more ruined "a bit" than you can be a "little bit" pregnant. It's binary thing -- it's either ruined or it's not.
If you still enjoy TOS, TNG, DS9, and VOY, then they haven't actually been ruined for you by PIC. Which makes sense, since PIC depicts the Federation as realizing it's done wrong and making amends.
1) Does that "gloomy atmosphere" include the bright, sunlit vistas of Chateau Picard? The glossy campus of Starfleet Headquarters? The sunlit neo-futurist Coppelius settlement?
2)
Dystopia is not a synonym for
story that is sometimes sad. It is a very particular word that refers to a depiction of a society which has become fundamentally authoritarian and oppressive. The Federation in PIC has embraced some bad stuff, but it's not a dystopia.
Because the creators wanted to do a story about a society that is fallible but fixable, in order to inspire us in real life to fix
our fallible societies.
"You keep using that word. I do not think it means what you think it means."
This is absolutely false. There is no indication whatsoever that the Federation in PIC has any of the following traits necessary for it to be a dystopia:
- suppression of free speech
- class-based oppression
- loss of political democracy
- racial oppression
- lack of privacy rights
- loss of individual rights in general
- use of state violence to suppress dissidents
Because the creative purpose of PIC was to inspire us to go out and fix our messed up society. The creative purpose of TNG and VOY was to reassure us that things were gonna get better by themselves without us having to put in the work. (The creative purpose of DS9 was to challenge us to ask ourselves if the message of TNG was really honest; PIC starts from the understanding DS9 provided that TNG's message is
not honest.)
PIC was to challenge you; TNG wants to reassure you.
Because it's politically and psychologically dishonest storytelling. The Picard we saw in TNG had the luxury of always choosing to do the right thing because TNG was written in such a way that he always had enough political power to get away with it. In TNG, going up against a powerful corrupt admiral when she starts a witch hunt does not damage or destroy his career in "The Drumhead;" in reality, this choice would almost certainly lead to months of internal Starfleet politicking and his possible loss of command. In "The
Pegasus," Picard casually arrests a member of the admiralty and exposes the UFP's treaty violation to a hostile foreign power; in real life, he'd be damned lucky if he got an honorable discharge.
PIC is starting from a fundamentally different creative conceit: "What if Picard tried to do the right thing, and he
wasn't powerful enough to get away with it? How would he react psychologically, and how would the galaxy react politically?" And that's a far more honest place to start your writing from than, "It's the 24th Century and
We'll Never Have Problems Again."
Why does it matter? Being an android is fine, so why should you feel negatively about him becoming one?
Sigh.
First off, when Picard dies, he dies a hero. He is not a loser -- he is a man who has overcome a decade and a half of depression, institutional inertia, the concerted efforts of the Zhat Vash, and even Coppelian nationalists, to forge a real and meaningful peace and lead the Federation back into decency.
Secondly, he dies and comes back to life for the same reason heroes do throughout Western fiction:
It represents new life and rebirth. I mean, hell, him encountering Data one last time is literally Orpheus descending into the Underworld before returning to the land of the living. Frickin'
Harry Potter died and met Dumbledore before returning to Hogwarts to defeat Voldemort -- you gonna call
Harry Potter a dystopia and complain about why Rowling thought it necessary to kill him, too?
Complaining that
Star Trek: Picard starts from a place of psychological darkness, climaxes in a heroic death, and resolves with rebirth and new life, makes about as much sense as claiming that it's bad that
The Divine Comedy starts with Dante travelling to Inferno instead of just immediately going to Paradise.
You are objectively wrong. You may find them too gloomy for your tastes -- in which case, you have bad taste and I don't want to be your friend -- but it is just factually inaccurate to call either DIS or PIC "dystopian." The Federation is a liberal democracy in both shows.