The embattled former Congressman has withdrawn his bid to serve as the next attorney general after widespread backlash