Growing up Catholic, I always figured that it was meant to be paradoxical, to drive home the Christian message. This horribly sad event that is so painful to imagine happening, this event was the most important Good thing that happened in human history. So we have to call it Good Friday.

Like many folk etymologies, it sounds like it's not quite right, but it was intuitive at the time...