Why is FF7's shocking moment considered the most shocking *spoilers*

[--OkeyDokey--]

Okay, it's Aeris, not Aerith. And it was shocking because players spent the first few dozen hours levelling her up and following her relationship with Cloud. For a main character to suddenly die and never come back is unexpected, no?