US president has been cautious in supporting Democratic candidates amid persistently low approval ratings