I found the problem, Qubes OS needs the wireplumber package for sound to work and it’s not installed by default when installing pipewire-pulse:
apt install -y --no-install-recommends pipewire-pulse
Because wireplumber is not a dependency of pipewire-pulse, it’s only a recommended package.
I’ll update the “Advanced way” in Waydroid guide to also install the wireplumber package.