Although such adapters
exist, they can be very expensive. It is also impossible to exclude a problem with the drivers.
You can buy BlueSCSI (with support for
initiator mode) to connect the disk and create an image on the SD card.
Then try to mount the resulting file via
fuseHFS, I once tested it on macOS 12 Monterey (Intel). But it's not a fact that it will work on Sonoma (AppleSilicon), because this project has not been updated all this time.
But the easiest solution would be to buy an old PowerMac, or ask your friends about the availability of these computers with a built-in SCSI or SCSI card. You can copy data either over the
network or via a USB drive or another HDD with HFS+ partitions that are still supported by macOS.
IDE to USB adapters also exist, they are cheap, and there should be no problems with them.