Hmmn.
"On a rare day going into work, my work-from-home husband, was not pleasant and charming about getting me coffee"
What part of that sentence might be the trigger for your husband being unhappy?
Because at the time of the event I expect your husband was going "Yippee, finally going into the office, this is so exciting! My wife must share this excitement! Wait! I must fetch her coffee on a coffee run!"
You have a very nice arrangement. You treat your husband mon-fri, because part of that is him treating you at weekends. Which you really appreciate.
You need to talk and be heard. Because your husband fetching you coffee is part of your well-being. He needs to be told how important and happy that makes you.
But I can honestly say, your heaven is not everyone's heaven. Your husband may or may not share it. Your husband may not appreciate you going out on a cold morning to fetch him coffee mon-fri, whereas you relish it?
But if he knows how important it is to you - then he knows to respect it.
And you're his wife. Did you not pick up on the fact he really did not want to go into work? Does he have any issues at work? Or did he just not want all the fuss of getting work dressed and commuting? And then you piled on the pressure by expecting coffee to be delivered to you as well?
It's a minor niggle in the waters. If he knows how happy, and special it makes you feel when he does the coffee run/ letting you lie in at weekends, he will feel more secure and have clear guidance on how to make you happy.