No, this cannot work, because S-ATA is a storage interface while USB is a universal bus. You can “convert” USB to S-ATA, but not vice versa.
Do not be confused by PCIe Mini Card adapters. While PCIe Mini Card does indeed carry USB, mSATA does not. Because it is not PCIe Mini Card, it just uses the same connector.