I was in a no sex, no intimacy relationship for years, and it was awful. I wish I'd got out much sooner than I did.
DP and I are very close on an intimate level, so when sex is not on the cards for either of us, we are still intimate, sleep naked for example or cuddle. We have sex most evenings, be that a quick one or a longer more sensual one (multiple activity ;) )
We also do it during the day on occasion, in fact a few weeks ago we spent all day in bed and had a dominos :) was brilliant and both felt like naughty teenagers (own our own companies so we can take time out if we need too)
Two DC, have a lock on the bedroom door and have learnt how to be quiet :)
But... we did have a dry spell after miscarriage number 6, I was terrified of getting pregnant, and another loss. We still remained intimate and honestly I think that's the most important thing. If you love your partner and your close then it doesn't matter how often your having sex.