Nitrogen can cause a “high” (aka nitrogen narcosis), but this effect only occurs at high pressures. So it is only a practical concern for divers, because they have to breathe high pressure air. Some divers replace the nitrogen in their tanks with other gases to avoid it.
It is unrelated to asphyxiation, and can occur even when the lungs are properly exchanging oxygen and CO2. It is a poorly understood direct interaction between high pressure nitrogen and the brain that does not occur at atmospheric pressure.