I just created another thread here, I'm seeing similar behavior.
https://xcp-ng.org/forum/topic/9025/usb-external-sata-enclosure-problems?_=1715782369050
For now, my workaround is to create a drive passthrough SR.
https://forums.lawrencesystems.com/t/xenserver-hard-drive-whole-disk-passthrough-with-xcp-ng/3433