Sony WH1000XM3 (bluetooth) will not register as an audio device, so no sound is played

Your XM3 is recognized by your system.

But your Pipewire cannot “see” the presence of XM3.

Can you check your bluetooth config in Pipewire, as per guideline here:
https://wiki.archlinux.org/title/PipeWire#Bluetooth_devices