The fact that I was excited and optimistic for that date makes me question my own judgment

It’s good to be excited. All you can do is give him your best you. If he’s a putz, you just have to move on. Hopefully you’ll at least get a decent meal out of the deal.