Why do I get so weak from watching piercings?

Squeamishness. My guess is that you associate with piercings with pain. Feeling weak is a physiologic reaction of squeamishness.