Jennifer, I'm not an expert on the health effects of closed cell foam. A lot of people live in houses with closed cell foam and have no health problems from it, at least not short-term, acute problems. I do know of one person who had it removed from her crawl space because she was convinced it caused her dog to get sick, but I know only what she told me.
For large jobs, professionals such as Dr. Energy Saver use two-part foam, which comes in larger containers. With 2-part spray foam, it's necessary to mix separate resin and catalyst compounds at the application nozzle. Combining these ingredients starts a chemical reaction that creates expanding foam. Contractors use small 2-part foam "kits" to air-seal an attic or to seal and insulate ductwork. To insulate an entire attic or wood-framed wall with spray foam, the resin and catalyst compounds are pumped to the application nozzle from 50-gallon drums in a specially equipped truck.