For those who would like some real expert analysis of the flight, please take a look at Scott Manley's excellent video:
I'm no rocket expert like Scott but I'm been following rockets and particularly SpaceX's Starship development for some years. I'm not a fan of Musk in any way, shape or form as a person (in short, he should stick to engineering and otherwise keep his mouth shut) but I do fully recognise that the SpaceX engineers and support staff are an incredibly talented group of very hard working people.
Despite the media trampling on almost everything that SpaceX does (often due to Musk hatred) it's not surprising that they combine their 'talents' of generating even more Musk hatred along with their normal distortions of the facts and inherent negativity to create yet another "Starship Failed!" narrative.
FWIW, despite both the booster and the ship eventually exploding, this second Starship flight test was a considerable improvement on the first one in April. Some bullet points on this second flight test:
The pad wasn't severely damaged this time, in fact there was only relatively minor damage and that was mostly to some easily fixed wiring on the 'arms' (nicknamed the 'chopsticks') which lift and cradle both ship and booster, plus the separate ship Quick Disconnect arm sustained some damage (this is used for fueling, power and telemetry to just the ship/second stage), and some storage tanks that were already dented received some additional dents from the shockwave on launch
The newly installed water deluge system worked extremely well (it was mainly this which prevented any pad damage)
All 33 booster engines lit and stayed lit until most were commanded to shut down at the planned stage separation
Booster and ship maintained their planned trajectory and speed AND passed through Max-Q with no incidents (Max-Q is when a rocket experiences maximum dynamic pressure, therefore there are major stresses on the vehicle)
The new Hot Stage Separation of ship and booster went very well (first time that SpaceX have tried this)
The problems only started after stage separation when the booster started its planned reorientation and the Flight Termination System (FTS) was activated due to some problems - Scott's video explains that well and what he suspects went wrong
The ship continued just fine until about 5 minutes later when it was about to shut down its engines for the coasting phase, something happened resulting in rapid fuel loss, apparently triggering its FTS. Again, see Scott's video for details on this
Compare and contrast with the first flight in April - this second flight achieved a great deal more.
So, all in all, it was a great success. Of course it didn't achieve the hoped for semi-orbital insertion of the ship, but maybe next time ...... I trust SpaceX's fantastic engineers to resolve issues as progress is made with this huge ship via SpaceX's usual rapid reiteration and testing.