I had my tongue pierced for about six months. My SO reported no difference in oral pleasure.

I got rid of it long ago, and for that I'm glad, it didn't mesh well with my job at the time, and it just wasn't generally for me then, definitely not now.
But I can understand how some people enjoy the visually arousing aspect, if that happens to be a turn on for them.