Sheetrock on 24 inch centers needs to be 5/8" thick.
If the metal was open on the eaves, and there is a ridge vent, then the air flowing in from the eave, and then because it gets so much hotter once it gets into the attic space, it goes up to the ridge vent, which keeps the underside of the metal dry. This is long proven, keep it simple technology that works.
Since you say that your insulation got so heavy that it caused your sheetrock ceiling to collapse, then you either had a leak, a lot of leaks, or no air flow from your eaves to your peak.
Adding plastic or tyvek to the underside of the roof would have made this worse. If it was under the metal, and over the pulins, then the metal itself would have stayed dry, but the underside of the plastic would have created a massive amount of moisture.
I have seen plastic used under the insulation and above the ceiling before on a church gym with a basketball court. There, they had a guy that they where paying to clean the gutters, but he never did. Over the years, the gutters became so full of leaves that had decomposed into dirt that when it rained, the water ran from the top of the debris under the roof and into the building at the eaves. It settled on the plastic, where it just sat. It would get so full, then no more water would get into the plastic, and then it would just run out over the sides of the gutters. One day the plastic started to leak a little bit and a lady walking in the gym for her morning exercise, slipped, fell and hurt herself. I was hired to fix it. I cleaned the gutters and drained the water out of the plastic. I used a lift, I poked a hole into the plastic and I filled up dozens and dozens of five gallon buckets with water from the plastic.