...Buying the S&P 500 - could go to zero tomorrow - complete ruin!...
Bad example. The SP has a zero chance of going to zero tomorrow, or ever, simply by it's design.
On the other hand, that ETN called the "XIV" had a 100% chance to go to zero, by design. It was even in their prospectus. And thus it came to be, and is no more.