The president's standing hits a new floor as inflation concerns and Democratic momentum complicate the GOP’s midterm outlook.