Open-cell is also known as half-pound foam. It has an R-Value of 3.5-3.6 per inch, and its density is bout 0.5 pounds per cubic food. Low-density foams like these are made partially from raw biological materials Carbon dioxide or water is also used in the makeup. Open-cell uses far less material than closed-cell, but its R-Value is lower. Also, open cell requires a vapor retarder (like gypsum wallboard) and is riskier when used for roof sheathing. It's not highly recommended that you use open-cell insulation if you live in a cold climate unless you have that extra barrier. You should also compare how much money you spend versus how effective the open-cell insulation is wherever it's installed.
What do you mean by "our AC units require fresh air ventilation"? Fresh air doesn't come from the attic. If there's an atmospheric combustion appliance in the attic, such as an 80 AFUE furnace, then you shouldn't be encapsulating the attic anyway. If that's the case, you don't want spray foam on the roofline at all. You can either change out the furnace to a sealed combustion unit or do your insulating and air-sealing at the flat-ceiling level.
If your foam pulled away just a little bit, Jamie, and they were able to fix it with just a little bit of touching up, then it wasn't as bad as the house where I saw this problem. As the last photo above shows, it had pulled away significantly from the studs and rafters, and it was all over the house. This was closed cell foam, and interestingly, it didn't pull away from the horizontal framing members, just the vertical and sloped ones. They did some touch up, but that wasn't enough. I don't know how this one ended up getting resolved. I think maybe the contractor came back and sprayed cellulose on top of the foam.