There is no "should". This foolish and, I think, exhibitionistic piece in the WSJ, How Often Should Married Couples Have Sex?, has been getting attention all over. I don't think it is very illuminating. Sexual frustration, however, does make both guys and gals cranky, and tends to make them want to look elsewhere for their instinctual romantic and sensual drives (which normal people do anyway, but even more so).
In my professional opinion, younger guys seem to be OK and relatively calm with sex twice daily. They are monkeys. Older fellows seem to get by with anywhere from daily to 3-4 times/week, depending on how hard and long they work at their jobs. Women are an entirely different topic, but my general advice to women is to remove the TV from the bedroom. Not to worry ladies - they will put it back in our bedrooms 24 hrs/day when we're demented widows in the nursing home. We can catch up with our shows and movies then. Carpe diem.
Apropos of the topic, I saw that Glenn Reynolds linked this book: Lube Jobs: A Woman's Guide to Great Maintenance Sex. Library journal commented about it, "Most people spend the largest part of their adulthood slogging through committed relationships, and they need books like this."
Good cozy marital snuggles can make up for a lot of troubles. But "slogging"? If you're slogging, it's your own darn fault. I have patients deep into their 70s and 80s with quite satisfying and jolly sex lives even when they know far more than they want to know about their spouses, and when their equipment is not what it once was. We are, in part, biological beings.