The rev limiter prevents the car from going to higher rpm, in which causes the misfire.

So in N and P it doesn't go to a high enough rpm to cause the misfire.
But in 2nd and 3rd it misfires.