When they took the field for the first time, they did so with No. 1 overall pick David Carr starting at quarterback. Carr had put together an outstanding senior season at Fresno State and was the obvious choice for the expansion Texans with the top pick. Sadly, they forgot to do anything about protecting him (to be fair to Houston, multiple players they had been counting on to play key offensive line roles got hurt, including top expansion pick Tony Boselli, who never played a down for the team).
As a rookie, Carr was sacked an NFL-record 76 times, and never really recovered from that shellacking. He threw for a career-high 3,531 yards in 2004, but was sacked 49 times. He followed that up with a 68-sack season in 2005, then was taken down 41 times in 2006, his last season in Houston.
You may be surprised to learn that Carr is still in the NFL, in his fourth season of backing up Eli Manning for the New York Giants (interrupted by one year in San Francisco). He hasn't thrown a regular-season NFL pass since 2010, but that didn't stop him from collecting a championship ring last season. Or a salary of close to $1 million this season. Plus, as the backup, he's probably getting hit a lot less.