Is it normal to not be able to wear tampons due to pain?

Probably not. Most women can wear tampons. If you are having pain with a tampon, by all means, don't use one. See your pcp/gyn and get checked out. You very well may have a treatable reason for the pain such as an infection or other cause of irritation. Your body is telling you the answer and what to do. Listen to it.