Six weeks is the bottom of the curve, not the starting line
Being cleared for sex and being ready for sex are two different events, often months apart.
At around six weeks someone tells you that you are cleared. Most women hear that as a statement about their body. It is not. It is a statement about wound healing and infection risk.
Measured across the whole perinatal year, sexual function is at or near its lowest point of the entire year at about six to eight weeks. That is the normal trajectory. It is the expected shape of the curve, not a sign that something has gone wrong with you. Scores climb back toward where they started somewhere between six and twelve months, and a substantial minority of women still have pain at a year, more if there was a significant tear.
So there are two questions, and they need asking separately. Is it safe. And is it comfortable. A clinician can answer the first at six weeks. Only you can answer the second, and the answer may be no for months without anything being wrong.
"If it still hurts in three months, what do we do then, and who do I see?"