The Senate Democratic leader is increasingly finding himself out of step with both his party’s voting base and his colleagues in Congress, writes John Bowden