I don't think that celebrities do much to inspire many people to get piercings or tattoos, having been involved with the rock music/biker scene for as long as I can remember I saw many more body adornments of all kinds just on regular people than you ever see on celebrities,even today, tattoos and piercings weren't anywhere near as mainstream 20 years ago as they are now. I've had friends who are tattoo artists and friends who are literally weighed down with facial peircings, I really don't pay that much attention to these things anymore,they are so much of everyday culture these days. To be different now you have to not have a tattoo lol.
I'm quite surprised how much it seems people ARE judging people on their tattoos/body jewellery and quite disappointed.
The worst case of bigotry I ever experienced personally was several years ago when I was very involved in playing the clarinet and I just happened to mention on a clarinet forum that I had a pieced tongue. The rather conservative (it transpired) mainly American membership having chatted amiably online with me about instruments and music for several months suddenly began accusing me of everything from devil worship to drug use and prostitution.

Personally I judge people much more harshly if they smoke than if they have a tattoo, especially women, I think that women smoking looks absolutely horrible. Terrible double standard I know but I'll forgive a good looking guy if he smokes lol.