I am a bit of a wimp and my pain tolerance is pretty low so does that mean that it would hurt to get my Tongue pierced?

You do realize you will have a lifetime of problems because of a tongue piercing, right? -- maybe days or even weeks of piercing pain, infections, food getting stuck in the hole, teeth/fillings chipped and broken by the ball, speech problems, clicking when you talk, perhaps breathing problems. Buy yourself a pretty top instead.

Ive had my tongue pierced for about 8 years as long as your careful with it it shouldn't cause too much problems. Getting your tongue pierced shouldn't hurt at all. The swelling of your tongue isn't good but Listerine does help that.