You can test this yourself. Flip your bike upside down, shift it into a gear that you use to accelerate, take a torque wrench with hex socket and put it in the left pedal socket on the backside of the crank like you would when installing it. Then test the torque required to get the wheel moving. You would find that these numbers are minimal.

Also gyroscopic effect has very little to do with the bike staying upright. The reason a bike stays upright is because of the trail interaction and camber thrust. When the bike leans left, camber thrust of the tire makes it turn left, which moves bottom of the bike to the left, correcting the initial lean, while the geometric trail prevents the tire from turning left completely.