If it was a translation error:

First, how was it missed when its the name of a major character?

Second, why did they not fix it in the original PC port, which fixed every other mistranslation and grammar/spelling error in the game?

Third, who argues that "Tina" is Terra's real name? Because that was a translational change as well.

Fourth, does anyone actually like the sound of "Aerith"?