Pain is a very subjective thing. What hurts a whole lot for me might not hurt very much for you. Wrist sprains, just like any other injury, will vary in pain levels between different people.
The amount of damage and type of injury will also determine how much pain you have. Usually a more severe sprain will hurt more than a minor one.