In glancing through this list, some of these make me go "hmm." For example, MySpace is an entry. While it did eventually die, I'm not sure I personally would count myspace as a startup failure -- it got to huge scale, got acquired, and still had niche activity for many years of gradual decline post-acquisition. Certainly, the startup founders and investors had a successful exit.
- Pebble
- Udemy
- Viper
First of all, it's not a startup it's a feature.
Second, in my country this service exists, you can make deliveries with uber and it's used for package delivery as well as signing contracts.
That money wasn't purely wasted, it went into salaries and other products. At least half ended in exits and became a part of another company.
The ability to fail and fail big is what makes the SF tech scene special... people aren't afraid to try something audacious. And sure, the world could take-or-leave most of these products, but I don't really see the point in this negative framing.
For example - Domo is still publicly traded and does $300M in revenue: