I think it's okay.

He's gotten to know you at work.

There must be some interest there as he did ask you out.

And then there's alcohol.

That always plays a role.

He knew you were drinking.

Try not to replay the events over and over in your mind.

Move forward and let him to continue to see the great person he became friends with in the first place.