I had Aeris death spoiled for me before I got to it, but even then, I didn't really feel anything when I found out or when I got to that part. Now Cid from FFVI on the other hand (assuming you let him die, which most people do at least the first time) had more of an effect on me. It led to one of the more interesting scenes of the game, which was also way ahead of it's time as far as video game story telling.