The unfavorable poll comes as Musk prepares to step back from the Trump administration to devote more time to his businesses