It’s even easier than that. The missle flies in cork screw of the same diameter each rotation.
The “pin wheel” effect is caused by the force perspective of the rocket flying away from the viewer.
(That is, the loops closer look bigger and the loops farther away look smaller.)
The video shows it forming from the middle.