My initial impression of the Starship SN8 12.5km test was that it was a partial success and therefore a partial failure, but the more I learn about it the more I'm left to conclude that it was much more success than failure. Watching it realtime the loss of the first engine appeared unplanned ... ditto the second engine, but when they fired up two engines at the end it showed that the earlier engine shutdowns were planned -- at least one of them anyway. So, it we take the news from SpaceX that the crash was do to low pressure in a header tank it puts the failure down to that singular issue -- still, they've been failing with tanks a bit too much for my taste. The green exhaust seen in the final seconds was put down to the copper in the engines burning up, but when I saw it realtime I thought they were using TEA/TEB like they use with the Merlin engines. Since the Raptor isn't supposed to use TEA/TEB and instead uses a spark torch setup I thought they'd used TEA/TEB as an emergency engine restart, but, consuming copper fully explains the green color so no TEA/TEB.
Blue Origin, in operation two years longer than SpaceX, has yet to put anything into orbit!
Brian