No not really, all C02 does is to starve the fire of oxygen which it needs to continue burning, at best it will just add more C02 to the atmosphere as it will disperse there when they stop spraying it on the fire.
Happily collecting things all my life...