Shit as an investment? Sure.
Shit in terms of value to the public? Sure.

Shit as a company? I would have to argue no. They were stable, in business for 16 years, had cash on hand to fund current operations for another 10 years, kept people employed, and developed multiple technologies that are now industry standard for web development.

Ignoring their product themselves (which I think is probably neutral, but is far too indepth a discussion for Reddit, regarding the good versus bad it enabled), that's basically what corporations are supposed to philosophically do for society: Employ people and improve the business sector as a whole.

At least for the moment, Musk has disrupted all of that. But, in terms of whether or not that was a good business decision for him, all we can really do is speculate while we wait and see.