I would appreciate some details on the implementation of isolation for multi-tenancy. Are the worker nodes shared?

Sure! Each instance of Postgres runs inside a qemu VM, inside a kubernetes pod. The VM provides isolation, autoscaling, metrics, and (eventually) live migrations. These VMs share AWS Metal nodes.

Source code here: https://github.com/neondatabase/autoscaling

Same here!