I've wondered what his life was like afterwards. After all, "What do you do for an encore?" I hope he was able to enjoy faithfully doing whatever was needed each day without comparing it to his moment in the limelight.
The stories will say that he'll be remembered forever, but forever is a long time--only One remembers that long, and He has somewhat different standards than we do. We'll do our best, though.
Rest in peace, and may the Lord receive you to himself.