Actually, the game says that her prayer DID work, but that Sephy's presence blocked it. Her dying was just a way to smurf with Cloud. The plot really wouldn't have changed that much, if they had decided to let her live.