The former New York City mayor was a 9/11 hero. But his last big job, defending the president, is a role too far