Kurt Warner in the hall of fame is a lock, regardless of the outcome of the Super Bowl.
As someone mentioned, it'll be interesting to see if he returns to Arizona next year. To me, at his age he seems to have lost some mobility (not that ever had much). He still has the accuracy and the arm but time isn't on his side and I can't see him wanting to go to another team, and having to learn a new system. He's really got it good in Arizona with his group of wide receivers.
Leinart hasn't gotten the job done when called upon, so there has to be some doubt whether he's the right man for the job. But I'm not sure if he's been given a fair amount of time to prove himself yet (too lazy to look up the stats)..