Lazy's right, I would agree that internal friction is also a significant factor, and that would account for a good percentage of the holding power. On the other hand, bleed down after sitting ends the very second the engine starts to rotate again - when the vehicle starts to move. With as little as 1/2 of a crank rotation you'll get compression in the next cylinder that's coming on to its compression stroke(assuming 4 stroke engine with at least 4 cyl). So if you're in 1st gear with a 4:1 ratio, it takes 1/8th of a tire rotation (to create 1/2 of a crank rotation)to move from the bled down (from sitting) cylinder to the next one ready for the compression stroke in the firing order.
Anybody that's yanked on a chainsaw with a flooded spark plug and felt the yankback from compression has felt this. Now pull that plug out of that same chainsaw and yank on it with only internal friction holding it. It just spins freely and easily to clear the flooded cylinder.
Having cranked over a v8 (that I was rebuilding) by hand with and without plugs in it, my rough guestimate is that it was at least 2-3 times as hard to crank it with plugs in than without...even cranking slowly with a breaker bar and a socket on the harmonic balancer, 1/8 of a crank rotation at a time.
Internal friction does account for a good chunk of the holding power, but on an engine in good condition, the very second it starts to rotate even a little, the compression builds fast and hard, and that's what holds it.
For those reasons, my own opinion is still that compression and to a lesser extent, internal friction is what holds you when you're stopped. The more mechanical (dis)advantage you create by putting it in a low gear, the harder it's going to be to move those wheels.