That's the one. It was quite a popular upgrade from drives like the Fusion IoDrive Duo and Intel 710/910 back in the day. Honestly the 710/910 might have better compatibility with a PCIe G5 as they are a SATA/SAS to PCIe bridge. No way that would work on a G4 though.
I remember people where using them in the Mac Pro 5,1 with pcie 2.0, it hit around 1300 MB/s. 800 MB/s is very impressive on the G5, in theory you could get up to 1000 although if it's worth the effort is another question.
Huh, I completely forgot it was pcie on mini-SAS. The 2.5" chassis was probably what threw me off. SAS does work in Leopard, although NVMe is out of the question of course unless someone writes a driver.
This thread goes into detail on what drives supposedly have an AHCI mode, the 750 pcie included. Intel might be able to confirm it although they never provide much help on EOL devices.
https://forums.anandtech.com/threads/nvme-drive-booting-in-ahci-mode.2500796/