Help!!!!

My bf and I tried having sex last night and the foreplay was amazing but when it came to actually doing it. He wasn’t able to get hard! This is the first time I’ve been with him in a sexual way and his dick is small and he was having trouble. It was horrible! How do I tell him? or what do I do!?? I was so turned off!