Is it normal to have sharp little pains in a newly pierced nose ring?

Chances are it's the nostril screw tail piece in your nose that is irritating the inside of your nose thus the pain sensation. Rotate the jewellery around in the piercing so the tail curl is sitting on a different area of cartilage inside your nose. that should resolve the pain issue.