Unless you’re Ferrari or Porsche, you don’t want to be in the situation where your vehicle has future collectors’ value. That usually just means it didn’t sell very well (rarity).
Let’s keep in mind that Tesla invested in this truck to be the next F-150, which is the best-selling vehicle in the USA for the past multiple decades.
You’re talking about different things. A failure from a manufacturer perspective can be a major success from a collector perspective (see also the DeLorean).
Even the hated Edsel is worth quite a bit today.
Of course it might be harder to keep a Cybertruck running for 50 years due to all the computerized components. Restorers will probably be relegated to rebuilding Cybertruck bodies with new components.