If you’re going to have a significant crash then you’re probably just as likely to break a metal frame as you are a carbon one. The problem with carbon is that if you have a crash and there is no visible damage, will you fully trust the frame? I know people with carbon bars that have just failed out of the blue probably because the stem bolts were slightly overtightened, but there was no warning before they simply completely snapped in two. The failure mechanism of carbon is different to metal and you are more likely to suffer a catastrophic failure than with metal that will most likely yield and more likely to show signs that there has been some plastic deformation.
I love that SC video, but it’s not really particularly representative of real world crashes. I suspect if you were actually on a bike and took a direct strike halfway up the downtube at speed against the edge of a rock the it would snap in two, just as it would with a metal bike. It’s like F1 suspension struts – they’re strong in the direction they’re designed to withstand forces, but not particularly strong if the force comes in from a different direction.
I personally would buy a carbon frame if I had the cash, but I would be more concerned about abrasion damage from things like bike racks and rubbing up against things. I think i’d feel like I’d have to treat it with more kids gloves than a metal bike, not just because it is twice the price.