I personally don't find tattoos offensive. I've had one for 40 years and the colors have sort of faded and bled but it still doesn't look to bad. My GF has tats but she is substantially younger so the fading and saggy isn't an issue.
However, many people in the business world, both employers and customers find them offensive. So the need to be hidden during working hours. Many times lip, nose, and face piercings, and facial, neck and all other visible tattoos can affect your job potential. Might not be fair, but it is a reality.