This video by Scott Manley, the Scott astronomer, gives you a colorful explanation of the accident and cause. He noted that the strut supplier will probably not be used again, which is a good idea. He also discusses accelerometers placed around the rocket tracking vibrations and waves that helped to pinpoint the area of failure.
The most important point is that the Dragon capsule survived the explosion, indicating that a human mission facing a similar mishap might have had a safe landing. SpaceX is working on software and additional safety features in anticipation of such a need. That is very encouraging.
