Interesting question. From what I read Direct Storage is supported by PCIe 3.0 as well. I could not find a detailed answer but I would be pretty confident the game needs to be on the NVMe drive, not so sure about Windows.
As it’s a new feature to Win11 and no games support it yet it’s probably best to wait until the first games that have the feature release and see what the reviews say.