CO2 is not great. It will induce panic and at high concentrations is very irritating to the respiratory system.

It's used in some settings, because it's a trade off of distressing the animal when you move or restrain it. But it needs to be done right.

Nitrogen is far better because there is no sensory cue that something is different.