Last night sex was so painful. This is not normal for us. What could have happened to us?

Lots of things. Dryness, too rough, not mentally prepared, not emotionally prepared, infection and many other things could have caused painful intercourse. If the problem persists, then ask for help from your family doctor.