Is Apple Pay an instant bank transfer?

It depends on the type of card you use and how the company processes it. I have my debit card and when I use Apple Pay and use my PIN it almost always comes out right away. Other places it may take a day or two.

Apple Pay is a way to wirelessly charge a purchase to your Credit or Debit Card. As such charges are shown as pending until they clear.