From my perspective, owning a truck and SUV and using them differently for various use cases, the cybertruck is neither. So even if I ignore everything else I feel about it’s aesthetic, Musk, politics, etc. It simply does not serve many real world needs that I have. It put itself in a very narrow box of, only people that really like this quirky design and also like/feel indifferent to the tangential stuff will want to buy this truck. Oh, also you have to be able to afford it too. This is such a small addressable market for a vehicle to target. Was never going to work.
However, it provided content and distraction and kept the stock high longer than it should have and I feel like that’s what Musk continues to excel at.
The Ford F-150 Lightning also failed and it was a full truck. It similarly was way too expensive, both for consumer and Ford, and had some issues with towing (range).
I had a friend who 'preordered' to get Cybertruck and he couldn't justify the price which was $140k CAD, so he bought a new Chevy pickup truck instead for $70-80k CAD.
I found out the same with pickup trucks generally.
I got one, years ago. The bed was not large enough to readily hold full sheets of plywood (the minivan I owned before could hold full sheets!). And yet, the truck was long such that parking, maneuvering in parking lots, etc, was a pain in the ass (here the minivan was about tied with the truck).
So sucked as a regular errand-car, sucked for hauling sheet goods.
(Sold it during the tail of Covid when used car prices were skyrocketing for whatever reason. Never again.)