I have to say that the worst name that I've heard is ****head (pronounced Shh-theed). This girl was in a high school class with my DD two years ago. They had a sub one day and she wouldn't even attempt to pronounce the name.
A neighbor of mine is an early childhood teacher. You wouldn't believe some of the names she's told us. Twin boys named Lemonjello and Orangejello (pronounced Lem-on-je-low and Or-on-je-low).
Every time the Shy-theed name gets posted, someone says it's an urban legend. I wish.

This is second hand, but considering the soursce, I believe it. I know a minister who did some teaching at a school in a rather rough area before he found a church to pastor. The first day, he looks at the roll and sees "Sh*thead."

Was it a prank? A typo? What? So he goes down the roll with the students. When he gets to Sh*thead, he wisely asks her, "And how do you pronounce that?" Without batting an eyelash, she replied, "Shy-theed." Imagine THAT name on a business card. Given that he is a minister and really not a leg-puller, his story has credibility. That and the fact that I met a "Washateria" at Astroworld. Anything is possible.
Out of curiosity, did the Lemonjello/Oranjello (sp?) story originate out of Texas? In about 80% of the cases, it does, for whatever reason. A lot of folks don't believe that either, but I don't know. I have an male ancestor who was named "Orange" back in the mid-1800s.....and no one was even Dutch in the family. Why would someone do that? They'd probably never even seen an orange back then where he lived.

Anyway, Oranjello is not a huge leap from Orange.
BTW, if someone has never heard the name Athena, they won't even understand when you ask them, "You don't know who Athena is?" I'd probably crack up if someone said,
"Athena? Where did you get that?" Mentally I would be saying, "This place I used to go to as a child. We called it school. You'd be amazed at what I learned there!" But I'd just give them a polite explanation, after which, I would be considered an egghead, rather than someone who just learned what anyone ought to learn along the way. I can just hear it, "Little Miss Brainiac over there named her kid after some goddess or some such. Poor kid. Why couldn't she just name her something normal like Chardonnay, Lexus, Evian or L'Oreal?"
I too, do not get "Nevaeh" or "Heaven" backwards. Isn't that like naming your kid "Hell"?

I'm not sure the parents thought this one through.