I'll go with Wernher von Braun there.
He famously said that so long as you get telemetry about the failure, it's not a failure. We're talking about rocket science here, which often is edge-of-the-art and not just state of it. It's a high-risk business.
So long as they get data as to what went wrong, and how, they can improve on it. That's how progress is made. So, scratch a few million US$ right now if this goes wrong, but in the long run, once the wrinkles have been ironed out, things become more reliable and far cheaper.
Many people these days seem to have forgotten that big things don't happen overnight... big development takes big time, and in space technology, just about everything is big. Musk is sticking with it (like von Braun did, and many others during that crucial period in space travel development). I hope he will continue to do so.