One of Kurt Warner's most memorable career moments is leading the St. Louis Rams to victory in Super Bowl XXXIV, where he orchestrated a game-winning drive in the final minutes.