That's because there's times where that's a good idea, but also times when it's more likely to turn out to just be a slightly messier form of seppuku. Helo guys correct me if it's different for you. But as a fixed-wing guy, my IFR decision-making calculus is decidedly slanted in favor of the latter, not the former . . .
An example where I used it: ATC called and said "home field just went IFR @800OVC/3 what are your intentions?" I was coming in @500 feet (normal) and almost had the field in sight, with a cloud deck that was obviously no lower than 800 all the way in and no obstacles (I was well aware of the area around my home field). about 10 seconds after they cleared me for the contact approach I had the field in sight and was switched to tower. The reason I wanted a contact approach over SVFR is they still provide aircraft clearance with a contact because technically you are on an IFR approach. SVFR you're on your own. They just don't provide ground/obstacle clearance. Pretty benign.
Anything more complicated than that and I would absolutely agree that it's a bad move. Mountainous/Hazardous terrain withstanding, flying helicopters is different. When your wheelhouse is flying around at 500 feet, a ceiling slightly below 1k is not necessarily a big deal. Even in the FRS, flying SVFR was done all the time without raising an eyebrow. Unless you're in the mountains... Then you're playing Russian roulette with your life and everyone on board.
As previously mentioned, my former squadron had a similar incident back in 2010. The flight profile looked very similar. IIMC, spatial-D, rapid acceleration/decent rate. The main difference being they saw the trees right before they hit and went in to some crazy 60-80 degree flare right before they hit the trees and everyone survived