It would have been a joke had it applied more with something like sleepiness instead of drunk, because drunk doesn't apply much other than that stereotype, I'm not saying my way would be funny at all, it's just the reason why people think the joke went over his head. If the joke isn't more obvious to the direct situation than it is pretty hard to detect especially over text:)