TLDR;
Aerith died, but it was written with the modern “sensibility” of her presence being around to give Clear Emotional Support to characters (similar to Diana after she died in The Crown).
Ironically, one of the only times I will ever say that the writing was better in the original game, where her presence was simply…