The outgoing president’s approval ratings are comparable to Richard Nixon, who resigned amid the Watergate scandal