You can try a similar experiment to the one you proposed in a car with an automatic transmission. Stand firmly on the brake (with the parking brake engaged and nothing in front of the car, for safety), put the car in drive, and give it some gas with your other foot. You can easily get the engine to more than twice the idle speed without the wheels turning at all! (Don't do this for extended periods. It makes the torque converter get hot.)