As Elon Musk’s brief tenure within President Donald Trump’s administration comes to an end, he leaves with a significantly diminished approval rating, polls show.