The name comes from an unusual optical illusion which makes it seem that a car with the handbrake off begins to roll up the hill.
The phenomenon described, which creates the illusion of a car rolling uphill when the handbrake is off, is what gives rise to the name.