Midterm elections defeat marked a savage rejection from across the country of the president, his allies and his second-term agenda