Americans have a dimmer view of Biden's presidency than Donald Trump's or Barack Obama's at the end of their terms.