Ten pounds of N2 should go further than ten pounds of CO2 because there are more molecultes of N2 in a pound. At the same pressure, the N2 tank would have to be much larger for the reason you indicated. Instead, N2 will typically be kept at a much higher pressure in a much stronger tank and if that N2 tank breaks when full, as for example if it falls and the valve at the top hits hard on the floor and cracks off, the result will be much more spectacular.
Actually, I think they vent the tank so it doesn't explode.