Hi,
Migration of Physical RDM is not supported, that is for sure, for all migrations types. Regardless if is HCX or a "normal" vCenter vMotion.
For there are two options.
1 - On destination, create a new SQL server and migrate Data/DB.
2 - Convert it to VMDK.
Using VMware converter or not, you will always have downtime on that SQL server.