Open cell is cheaper, has a lower R value and it holds moisture. If sprayed against metal, it might void the warrantee from the metal company because over time the moisture in it builds up and rusts the metal.
Closed cell is more expensive, it has a higher R value and moisture cannot get into it. It's used for floating docks.
I went with a client of mine to look at a $800,000 house for sale that she was considering buying. It was a really nice house and priced below market for the area. The realtor said they where getting a divorce and wanted a quick sale. My first impression was that it was going to need a new roof fairly soon, which didn't make sense since the house was only a few years old. Looked like hail damage with so much of the rock coming off of the shingles and already starting to curl up. In the attic I found open cell sprayed to the roof. I believe that is why they are trying to sell the house at a lower price, because it's destroying the roof and it's going to have to all come out and then new decking and shingles installed.
I did a search online to see if it could be anything else and found conflicting reports. Some say it's OK, but there has to be a barrier to keep the foam from touching the decking and lumber that makes up the roof structure. There where also a lot of lawsuits about the damage open cell has caused in homes.
When I spoke to the guys at Muellers, where I buy my metal roofing, they said to never used open cell foam if it touches the metal. For me, that's all I needed to hear.
I've been told by other contractors and even one insulation guy that it's ok to use open cell, that it's blamed for things that where the roofers fault, or just people trying to sue for no reason. I don't believe them and will never use open cell foam.
Call your metal supplier and talk to them. If your metal rusts on you in a few years, or even ten years, will they do anything about it if you used open cell foam? Be sure to get it in writing if they say it's ok to use open cell foam!!!!