The third-party designer is clever to use the added rear space required for mirrorless cameras to push in a tilt/shift section.
I doubt we'll see a similar Nikkor in the nearest future, though. The F-mount tilt/shift lenses can do service on the Z bodies as well. in fact, it might even be easier to appreciate the value of the lens movements on the mirrorless camera.