Survey shows conflict is dragging down president’s approval ratings ahead of November midterms