Failed CO2 has in the past sent me knocking door to door asking to borrow a bike pump.
On any longer ride, I want to be prepared for multiple flats, means multiple CO2 cartridges which plus inflator weigh more than a pump.
I now stick with my old Silica Imperio/Campy head pump. I pick them up for $25 in the used bins. Plus you can't stick a CO2 cartridge in an Italian's spokes.