What does Manual vs Automatic push do?

In Auto, eligible open tasks are handed off to your connected apps on a repeating timer (the push interval), within your Active hours. In Manual, nothing is pushed automatically — tasks only go out when you press "Push now" (or push a single list, a selection, or one task). Each task is still only ever pushed once, regardless of mode.