While visually Celestia fits as Athena, I can’t help but wonder if Twilight wouldn’t have fit better
She’s the goddess of wisdom, the one to defeat villains everytime, the owl makes more sense for her, just as prone to take students as Celestia and also had to go through her own arc of appreciating friendship and empathy over logic and practicality
Who would be Zeus, then? The powerful but freaky Discord? The ruler of everything Fausticorn?
I think Celestia makes more sense as Hera.