Are excessive body piercings and tattoos intended to be attractive?
Not really.
It would not appear so.
They are related to medieval Catholic practices of "self-flagellation"and wearing rough wool or "hair shirts" as a penance and forbidding finery or nice clothes as a penance. Such garments "itch" or cause "pruritus" and are thus said to be of a "prurient" interest.
It's a religious sickness, which is a conclusion we come to from the outside world without prejudice. The reason being, excessive tattoos are not really worthy to be termed "vanity" as if the wearers of them were guilty of artificially enhancing their beauty, and the pieces of metal often worn in body piercings, again, are not in the category of "fashion jewelry" or "fine jewelry" that would be rebuked in church as following high worldly fashions or bearing finery. It's a baroque medieval place where ugliness and tackiness are permitted but beauty and simplicity is heavily rebuked.

People with too many tattoos and body piercings are displaying or showing off a comfort with sharp hollow needles and not with any natural bodily affection.
Mind-altering drugs are the likely attraction, not sex, and there is no effective church rebuke from any of these pulpits for the use or abuse of recreational or mind-altering drugs, especially in certain congregations of any named religion with too much of a "tabernacle" going on with a certain percentage of churchgoers "stoned" or high on drugs, and others offering mental health services professionally or on an involuntary basis.