It probably would. However, there certainly seems to have been issues and bugs with the adapter on Z camera, as revealed by the advertial blurb.
Hopefully Voigtländer/Cosina launches a dedicated Z version of the 65/2. I might be interested in such a lens myself, but for now, the old workhorse AF 60mm f/2.8 & 55/3.5 Micro-Nikkors have to make do.
I have both the 65mm and 110mm versions of the Sony Macros, and I have adapted them to the Nikon ZII, with OK effect. At first I was very enthused by these lenses on the Nikon mirrorless, but over time my enthusiasm has become muted somewhat. I find I don't use them... much at all. Something is lost in the adaptation. I agree with Birna. I too have had issues with various Sony-E to Nikon-Z adapters and don't much like any of them, and I have tried a few. Trying to make Sony lenses work on the Nikon mirrorless apparently is something of an oxymoron. I have moved away from this, even though I love Voigtlander lenses and have a stack of them. I too have several of the CV125 lenses, although I am selling one of them, never used, mint and in all the original packing.
I use the Nikon MC 105 Macro S a lot. I also have the Nikon MC 50mm, which is not in the "S" line, but I am not particularly happy with this lens, although I love the idea of wider-angle macro lenses. I don't use it much. How do others feel on the 50mm MC?
I seem to like the "S" line of the new Z Nikkor lenses because they are outstanding for the most part.
IMAGE using the CV 65mm Sony adapted to Nikon mirrorless.