That is NVMe. It won't work over SATA. There's no reason its should be restricted to SATA speeds. You can get a PCIe adapter card to plug in a PCIe slot on your motherboard and it can go full speed: https://www.amazon.com/dp/B07JKH5VTL
That's awesome to hear, going by what u/flaming_m0e I just didn't have enough knowledge of how HBA worked and now need to connect the SSD to a secondary controller. I do have SATA ports on the mobo that I can use for the SSD, I just need to figure out how to power the SSD and mount it somewhere internally. While doing some searching online, I came across another method I can use and that is to get a PCI M.2 or a PCI SATA adapter and use that to host the SSD or M.2 I would like to use for my VM datastore.