Politics or no, the price point ultimately dictated its maximum sales. By that measure it's a reasonable success, and if Elon was forecasting that they would sell multiple tens of thousands of vehicles per year at a $80,000 price point he needs to lay off the drugs. Elon sometimes seems like the living embodiment of "How much could a banana cost, Michael, $10?" parody of out of touch rich people.
I think if people who like trucks didn't see videos of things like the bumper ripping off when towing or minor failures leading to whole vehicle shorts it might have done better. The people who want trucks want resilience and ability to self-service more than the average car buyer.