Other people have already explained that you're not an idiot.

You're experiencing that "battle plans, and then the actual battle" thing that someone could tell you all about. You've done a great deal of preparatory work, and are thus ready for many things, this one wasn't obvious enough for you to plan for beforehand.

I don't know enough to offer advice, just...what's the English word for what I want? Sympathy?