What could have been? I remember being so excited about this at that point, I was sure it was going to take a significant chunk of [famous web services still around]. They even send me stickers for Cap'n'proto..
If I understood it well enough, the intention was to formalize/standardize self-hosting such that it became easier (and with an emphasis on security).
With that done well, perhaps the next step would have been ready-made images. I could see it reducing friction for people if they'd rent a VPS, upload an ISO/IMG, and the resulting system was reliably secure. Then they'd use the Sandstorm interface to install apps with a web GUI.