It depends.....
Ballistics is moderately complicated: the "correct" spin rate depends on the projectile's l/w ratio and mass. Those factors, which are also linked by projectile density, along with projectile shape, determine the "ballistic coefficient", the projectile's ability to retain velocity as it passes through the air.
Generally, pointed, longer bullets have longer ranges as they have their mass combined with a small surface area and maintain velocity. Common rifle bullets have a l/w ratio of 3:1 to 5:1, while handgun bullets are around 2:1.
If you take two bullets, a 2:1 ratio pistol bullet of 11mm calibre (diameter) and a 4:1 5.5mm rifle bullet of the same overall density, the rifle bullet will have half the mass, but twice the mass/area ratio and travel far further. As an aside, lighter high velocity bullets have less recoil for the same energy as slower, heavier, bullets.
This is somewhat simplified.
It should also be remembered that rapidly spinning bullets diverge from a straight line path due to that rotation.