Still a failure in my book, it blew up before it could deliver its payload so they couldn't do many the tests they intended to do.
It is possible they will have to add one more test launch to their schedule, delaying commercial operations because of that.
It is not a complete failure, but to me, it is more failure than success, even by SpaceX test flight standards.
Compared to the previous flight, that I consider a success, the booster catch was nice, but it is not the first, and they have plenty of tries left to perfect it, so it is not in the critical path.
they didn't get the telemetry after, what it was, 16 min(?) hope they'll find the reason which will be hard without black boxes like on airplanes. as every engineer knows it works flawlessly only at the end. if ever.
the booster was the same, great, but not surprising.
IIRC they had 30 cameras on board & who knows how many sensors (probably hudreds ?).
So even if an engine bay fire burned the electronics and interrupted all coms (or FTS blew it up) they should already have a lot of data by that point showing how it went wrong.
SpaceX has a way of making the nearly impossible expected. We have forgotten quite quickly that booster catch is still a very experimental feature. Return to base on this flight wasn't routine yet.
Didn't expect it to disintegrate completely. At least they figured out what happened. Well, one step at a time. But that means no orbital flight for next couple of missions.
ship looks to be lost. this was the main part, so it's almost complete failure.