To ditch or not to ditch?

Y’all.. I am begging for no judgment.. I am needing ADVICE. There’s this guy.. that I’ve known for a long time, and we have even hung out a few times. Fast forward, we started talking again.. and I was horny and wanted sex... so he drove over an hour, and rented a hotel.

I’m not horny anymore, and don’t feel like having sex.. so what do I do?? I don’t want to be rude by not going to the hotel, that he paid for and ditching him?