I have several Nikkors that I use with my a7Rii including 300mm/4 PF and 24-120mm/4 with the Commlite adapter.
It AF and meta data works.
There are lots of feedback on the subject online.
That said, the lenses focuses slightly slower ~85% of native, and VR really doesn't work.
I'm currently debating between Nikkor 20mm/1.8 or the new Tokina 20mm/2.0AF (native FE).
ps, just don't get rid of D5 until you have put a7iii to paces. I found a9 insufficient for some action shots where there are multiple subjects in a zone (e.g., soccer game). Nikon AF for sports is still better and more accurate. Haven't seen any a7iii AF comparison other than a single subject focus.