Even with counter rotating wheels to offset the angular motion, Gyro effect still applies, because the gyro effect works regardless of spin direction and counter rotation doesn't affect that.

The only affect where counter rotation offsets is to stop torque spin, like with a twin rotor counter rotating helicopter, which can fly without a tail rotor, or on the P38 Lightning, which had so much prop torque that they had to counter rotate the props to make the aircraft more controllable, or on the old Russian Bear Bomber, where they used twin counter rotating props to save stress on the engine hard points on the wing, due to the props being turned at an RPM such that the prop tips were traveling faster than the speed of sound.