When you are so drunk you are unable to maintain balance, leading you to stumble around. However, you are completely consciously aware of you're lack of balance, but cannot control it.
James: "I don't think I can stand up straight. I do indeed believe I have the stumblies."