Gyroscopic effect is not even significant. Lock your steering and you will fall over no matter how fast your wheels are spinning. (Which can happen with a badly pitted headset)