A New Orleans football legend reached the pinnacle of the sport, playing in three Super Bowls. Then he disappeared.