And that's the crux of it, I guess. Though I'm betting he eventually gets together with [insert girl here] and has some more crazy adventures. He probably get's sucked into another parrallel universe, leaving his wife and kid (?!) behind. They think he's dead and eventually move on, remembering how awesome he was. When he finally returns he finds them happy without him, and decides never to let them know he's still alive, but watches over them from the shadows, sad for his own loss but altruistically happy that they, and the world, are safe. He dies in battle against the second greatest evil that almost destroyed Hyrule (not ganon) at the age of 84, but not before passing on his knowledge to a young protege, and ensuring that the foe is vanqueshed through his own death in some sort of metaphysical way. I guess in death he transfers his triforce of courage as well, and probably finds a way to transpose death as the Hero's Shade or something. So he dies happy. No evidence for this whatsoever.