Actually I'm curious to know why you've asked this question ? :))
Never. Never happens .
Dates, people, and events confused, yes. But never verb tense
Mixing words up, slurring, being unable to think of the word you want to say, these all happen when someone is drunk. But mixing up tenses? Never happened to me, nor have I ever seen it happen to another native speaker.