It certainly did not "fail" on aesthetics. Few people would not take note of it, and it wasn't overly impractical. Some people hated DeLorean too, which just made it even more popular as well ...
Tesla forecasted selling 250,000 trucks per year by 2025
Actual sales
2024 - 38,965
2025 - 20,237
2026 to date - 11,586
This includes trucks that have been “sold” to other Musk companies.
This product was a complete failure, making the Ford Edsel look like a roaring success
The Cybertruck was released when the company was selling millions of cars a year. It did pretty much nothing for their bottom line, didn’t break them into any new markers, and fell far short of expectations.
They sold 9,000 DeLorean's _total_. It was a punchline in Back to the Future, it wasn't seen as cool at all.
If you see CyberTrucks and DeLoreans as successful, I'd hate to see what you call a failure.