The transmission pump is an offset vane drive pump just like the power steering pump, so similar sounds for problems would be expected, although I have never heard a whining 6L80 transmission pump.
As Nick pointed out, the engagement for forward movement requires pressure from the pump and the...