In automatic transmissions, there is a torque converter. This is like two fans, one connected to the engine and one to the start of the transmission. This allows the car to sit still while the engine moves.

As long as the engine is moving, the fan is blowing oil at the other fan, and so it's pushing the car forward. When you step on the gas the fan blows harder and so the force forward is stronger.