The US President is now vulnerable to investigations from rejuvenated Democrats after midterms wipeout – but the opposition may stop short of trying to remove him from office for an unprecedented third time, writes Joe Sommerlad