Despite his role in Trump's inner circle and overseeing DOGE, Musk's popularity is waning. A recent poll shows he's becoming more unpopular with the public.