and there's some genuinely touching moments like the death of the girl
How exactly was that touching? Riker deliberately chose not to save the girl and the crew gave him a pat on the back for it. For a series that depicts humanity that's still trying to develop new ways to heal people, the moment when one has the power to bring a dead child back to life is shunned upon. Why is letting this girl die a good thing? Should we go to every hospital and tell doctors to stop trying to revive patients the moment they flat line?
You know what I call characters who willingly let children die and feel good about it at the end? The bad guys.
What crew gave him a pat on the back? Both Data and Crusher looked stunned when Riker didn't bring her back. I understand Picard being wary of changing events that already happened and that they would normally not have the power to change.
, DC Comics Annual #1 gives a look at changing events that have already happened. It's written by Micheal Jan Friedman and John deLancie.