What makes fast decompression so dangerous for the fuselage?
Often it's the structural failure that results in decompression.

The comet (the aircraft in your example) was vulnerable to fatigue cracking that would propagate throughout the fuselage and compromise the structural integrity. Nowadays the fuselage is designed to stop such cracks from reaching further than the next spar and planes are retired when the number of cycles has reached the design limit.

There are factors to take into account when the vessel decompresses. If portions of the vessel are closed off from each other, then the pressure difference between those sections can exceed the tolerance of the divider and cause damage. This caused the floor to collapse when the cargo door blew off in Turkish Airlines Flight 981.