At least as of the last major macOS release, that will not work, because the PCIe LSI SCSI HBA driver doesn’t have the extra stuff needed to support external PCIe.

It’d be a pleasant surprise if Apple implemented that for macOS 26 but I wouldn’t hold my breath.