Does a snug piercing hurt?

OMGsh!!!!!!!! I just looked it up!!! eeeewwww....don't get one! YEAH!!!!!! It looks like it would KILL!