I have some experience of this phenomenon. Not related to red wine but to gin. I'm not sure what the common denominator is. Summer seems to be a factor. When it's a nice summer day, I'll take a pint of gin and tonic to the shed, to save coming back to the house too often. As the afternoon progresses, the quality of my work deteriorates.
Was your red wine experience in the Summer?