@Tema0
While not a nice experience, people do get confused in the middle of the night (and you also say he had a drink or two). And your description of what happened makes that seem the likely explanation.
Having said that you need to feel safe. If you are scared this will happen again then contact AirBnB asap and ask them to have him moved. I imagine he will be embarassed by what has happened.
We have had it happen a couple of times over the past four years.
Remember this is your home and you have a right to feel safe there - you also have a duty to act if you dont
Good luck