Really the harmonics are best understood as something like "wave height on the surface of a sphere". They tell you how the electrons (or whatever) are going to distribute themselves radially, not where they're going in 3D space.
Also FWIW: the much harder thing to grok here (at least it was for me), and that no one tries to tackle, is why the "l" number corresponds directly to angular momentum. In particular "l==0" doesn't look like there's any rotation going on at all.