But Democrats failed in their bid to capture the seat held by Senator Bill Frist of Tennessee , the retiring majority leader , as Representative Harold E. Ford Jr. was defeated by Bob Corker , the former mayor of Chattanooga .