I think a big part of the pain is the anticipation. You know the mental build up, so little ones can't have that because they are surprised. So I don't think it really hurts then too much.
I would never pierce my LO but I do not think it hurts them much but I am sure it will start to hurt a little more later, but you could probably just use an ice pack or shot of Tylenol if that dose happen.