Starship not separating, launch stand disintegrating, 5-6 raptors not working, HPUs exploding, all of those were failures. That doesn't mean the test as a whole was a failure, but you cannot say that everything worked fine.
Every millisecond of lift it gave was telemetry that will refine the end product.
This. Was. Never. Meant. To. Succeed. As. An. End. Product.
the launch, short flight and destruction was a wonderful success. Mistakes were definitely made... but thats the fastest way to learn! (As I often tell my kids)
Blowing up on the launchpad during fueling would've been a destructive test. So would splashing down in the ocean off Hawaii. That doesn't make them the same; one went well, the other did not.