Trump pick to lead federal watchdog agency withdraws after offensive text messages were revealed