haha, my cat does this with her food, every time we give her some, she eats all of it, if its too much, she'll eat as much as she can, throw up, and eat the rest, and sometimes throw up again lol. weve gotten it down to where she wont throw up usually though.
to OP: im inclined to say yes, a snake can be mentaly handicapped, just like any other animal. either that, or it gets way too excited at the thought of food and forgets to think about what its doing lol