Trump's approval has fallen to a second-term low as Democratic voters report greater motivation ahead of the November midterms.