Sex advice with Suzi Godson: 'My wife and I only have sex on Saturdays'

You have identified something that I believe to be 100% true, although it is not something that is easily verifiable. It is extremely difficult for psychological research to attribute mood changes to the absence of anything; much easier to explain them as a response to exposure, or a reaction to something.
Mood, in particular, is affected by so many variables that it would be impossible to make a direct connection between, say, sex on a Saturday morning and grumpiness on a Wednesday evening. Still, I am convinced that you are right because there is a wealth of research to show that having sex makes people happy, so it is hardly a stretch to suggest that the same might be true in reverse.