My mind is so blown. Definitely disappointing, but let's be honest: this is a win for SpaceX, given that this was the first fully integrated flight test of a very complex, very unproven vehicle. (Yes, the ship has flown before, but this was the booster's first flight.)
Did anybody else notice the Apollo-style maneuver to avoid the launch tower?
For a very loose definition of intact. It had a crater gouged out underneath it including under some of the supports. They'll have to rebuild that, and "couple months" sounds optimistic.
A failure would've been "oh shit we discovered another problem with the launch sequence, guess we're a few weeks behind where we wanted to be."
A catastrophic failure would've been "oh shit we didn't discover a problem with the launch sequence and it blew up on the pad and damaged our ground facilities."
A huge success would've been the planned mission.
This seems like, "Well, some thing went well, some went poorly."
If you watched the spacex youtube feed there's no denying it was a smashing success. The employees were clearly celebrating even after the Rapid Unplanned Disassembly.
That's exactly engineering. A complex system seldom has a 100% success on first launch, all engineering products are incremental success. There are thousands of small factors that can deviate a live test from their theoretical assumptions. The fact that they have got past the first hurdle for a completely untested product is worthy of appreciation. Just a few years back, everyone would have unanimously applauded the launch. But now, people are letting their personal bias about the CEO cloud their judgement about the achievements of the engineers working on the product.
Only in old fields with a long history of failures to learn from are engineers expected to be failure-free. You're absolutely right that civil or structural engineers should not be expected to build a few bridges or houses and hope that eventually they come up with a design that doesn't fall down anymore.
Starship is far outside the realm of rote engineering codes that just need to be faithfully executed. They've simulated and tested and validated as much as was reasonable, now they're working with and learning from full-scale prototypes. If it just worked, they wouldn't know how much margin they had. Now that it's exploded, they know a large number of components that were good enough for the phases of flight that it went through, and also the exact stress at which a particular component/system failed: that's incredibly valuable and useful information, and not something you can find on Stack Overflow or an ISO standard.
Did anybody else notice the Apollo-style maneuver to avoid the launch tower?