I don't reject the notion, but sex isn't the best foundation. If there is a connection based on something deeper, sure, having sex will perpetuate the connection. But trying to have sex in order to reach that connection really just doesn't work.
If you aren't connecting outside the bedroom, you're not going to get much sex. There are loads of articles written by men and women on the subject.
https://www.rwapsych.com.au/blog/female-sexual-desire/
The other thing most men don't realize is that women desire sex when they feel good about themselves. It has almost nothing to do with her attraction to you, but how sexy she feels in her own skin. So when she's sitting around in baby spit up and hasn't had a chance to take a leisurely shower/bath, and all-around feels frumpy and tired, she's not going to feel sexy or desire sex.
Another issue is cortisol. Cortisol is the stress hormone. If she's constantly feeling stressed out she will not desire sex. Most SAHMs struggle with this because their work place is literally always in their face - ugh the laundry still needs to be folded, dishes are piling up, the baby needs to be changed, etc. So instead of feeling relaxed at home, they are focused on their never ending job.
https://abcnews.go.com/Lifestyle/stay-home-parent-luxury-spouse/story?id=26022052