No — an autofocus motor in the body will not make older, manual focus lenses into autofocus lenses.
Any autofocus lens needs a motor — it's what does the "auto", after all. (Just like an automobile would be just a ... moble without one.) There are two primary places where this motor can be placed — either in the lens itself, or in the camera body. Each of these approaches has advantages and disadvantages, but that's beyond the scope of this question.
The important thing is that in-body motors need to deliver their output (in the form of motion) to the lens in some way. In order to do that, the lens needs to be designed for that connection. Usually, this is done via an autofocus screw — a drive shaft that connects from the body to the lens, and lenses designed to be focused in this way are sometimes called screw-drive lenses.
Now, historically, there's an interesting footnote, because one early autofocus system, the Contax AX worked without a connection to the lens at all. Instead, it moved the film plane within the camera body. That meant it could work with lenses not designed for it. But, this approach had many limitations (detailed in the linked article, if you're curious), and that's why it's just a historical footnote — it doesn't apply to Nikon or to any modern camera.
Also see What is an auto-focus motor? for more.