I've personally always found plot elements such as a character dying rather bothersome.
I played Guild Wars for 2+ years, the majority of it spent competatively. However, when I started, and the few times after I submitted to pvp, that I bothered to actually pve, it always bugged me that PCs can die, and I could resurrect them (or a party member could, w/e), and yet, if an NPC died, fission mailed. GW explained this away with saying you were chosen or some such, which didnt really make any sense in and of itself, as the game is, once you get the training wheels off, entirely team based, yet the "defining moment" in your particular PCs life (in the first one) was "Ascending" and doing it solo. This was rather odd to me, as everything before, and after was stricly co-op, but whatever, I am off track.
Back to the point, I can live with save points, and resurrections of the main character in a FPS all day, however, Aeris' death was rather bewildering to me, as the characters outside of cutscenes can quite literally die hundreds of times, and all that elicits is a "well, time to use a phoenix down." The idea that, if your whole party died you couldn't just phoenix down everyone back up was OK (although you apparently had like, ten other guys floating in the wings, but w/e nitpicking) so having a character die, unresurrecctably (yes I know its not a word, shut up) was just awkward IMO. And yes, I know that PCs in the FF series are like "unconscious" or whatever the fuck, but you know what, when HP reads 0/n, YOU ARE FUCKING DEAD. Too much deus ex machina to really have an impact. They needed a plot point, and while effective, it didn't stick out as any sort of "memorable" moment.
Now, if they had killed Mog, I wouldve been sad.