Veteran South Carolina senator polling poorly despite president’s support as 2026 midterm elections loom on horizon, leaving challengers scenting blood in the water