Don't want sex

Now it's not just that I'm not in the mood, I am just as much as before, and I'm extremely attracted to my SO still, but sex is just so painful. We use lube but even if it makes sex more comfortable, my vagina ends up very sensitive and raw after sex. No matter how slow or careful we are. I find myself avoiding it because it's just so painful. I explain this to him but it's making him feel like I don't want it and that makes me feel bad.
Did anyone have this problem? Does it go away? Or does it get worse?