People still hated it when it was announced, the online discourse was largely negative surrounding it. I remember being in my tech office at the time and we were all talking about how bad it looked.
None of this materialized. The truck that ended up in production was a traditional body construction, but with unpainted steel panels so it looks like the truck Musk presented. It ended up with all the drawbacks of a steel body, while being expensive and hard to manufacture
Once the structural body concept failed (has it ever been adequately explained why they failed?) it would have made sense to either drop the Cybertruck altogether, or pivot to a more traditional design. But ego prevailed, sadly.
IMO the big missed opportunity was a follow the model 3 with a 'model 2' - a smaller, cheaper car - probably in the VW Golf / BMW 1-series class.
I can assure you he was not.
But it didn't live up to the selling points, it is very expensive, has design issues that weren't necessary for the aesthetic, and the company's owner turned out to be a really horrible person contributing meaningfully to changes in my country that are dangerous.
This was well into the Tesla flamethrower/short shorts/funding secured/etc period of Tesla meme stockification. And pushing Dogecoin/crypto.
He certainly definitely wasn't the "darling of the left" by then. But you are correct that his image was significantly less tarnished by political meddling and later obsession with "woke/trans/culture war of the day stuff.
He was* the darling of the emerging meme stock day trader/gambler/WSB crowd which in broad strokes tends to anti-correlate with the "left".
And positive first reactions to that car came only from Musk fans bubble. I was seeing people calling it ugly from basically a day 1.
By the time of its delayed release, Musk had become deeply unpopular with many of that original coalition of fans and buyers, the truck was more expensive than originally promised, his new ‘base’ probably couldn’t afford to buy many of them, and it was structurally a fairly normal car underneath the steel panels. It also suffered plenty of embarrassing issues, which people were of course gleeful to publicise.
It could have been a cool funky status symbol, but Musk screwed it all up.