My First Shower Sex Experience Wasn't So Pleasurable Please Help

So last night, my boyfriend stayed over, he suggested we took our intamicy to the next level. We attempted shower sex and I say attempted as it didn't work out like I thought it would. When you see it in movies or on PornHub, it isn't showing the truth... or at least my reality was not reflected in this way. It's supposed be a sexy and steamy experience but instead I was so sweaty and there wasn't much room. My face pressed against the shower wall, hurting so bad every time he thrusted and pushed it wet dick inside of me.  I am so disappointed in the whole experience and I never want to attempt it again.   However he enjoyed it and wants to do more of it but I'm too afraid to tell him it didn't pleasure me as it will dishearten him! I don't want him to feel as if he did it wrongly... but I know I will.  Pls give me advice on what to do in the near future!! And if I try it again what tips could I use to gain more erotic feelings to get me in the mood. Many thanks Sapphire ❤️❤️