It often hits the cervix because of it's placement. The cervix is very sensitive. The pressure and dryness of the tampon can cause pain. Pain can cause dizziness.

edit: actually it doesn't even need to hit the cervix to be painful, just an object being in a place that isn't used objects being there can be enough.