Is There a Pickup Confirmation Transactional Email?

There is no pickup confirmation email - if you choose to Notify Customer when marking an order as pickup, the Shipping Confirmation email will trigger. It's the email that gets sent when an order is updated to Fulfilled.
In general, for pickup orders, we recommend leaving the Notify Customer box unchecked. This way, no notification emails will be sent for pickup and avoid any potential confusion.