The weight difference is pretty negligible. Plus, I'll sacrifice a few grams if it means not being stuck somewhere with no way inflate my flat tire.

Even if you don't get a lot of flats it's cheaper. 5 or 6 CO2 cartridges a year can add up. Especially considering you pay once for a pump and get unlimited uses. Providing it doesn't break...