Do snakebite piercing's hurt

(This applies to all piercings.)

It comes down to the individual and the piercer. If you have a low pain tolerance, it's going to hurt a bit. If you go to an inexperienced piercer, you are more likely to have a painful experience.

Side note: Pain should not be a determining factor if you really want to get any body modification(s).
Yes