Romantic move totally failed...

So I bought a nice piece of lingerie to surprise my SO last weekend. While he showered I lit some candles, put the teddy on, and waited on his bed (after I spent 10min trying to “arrange” myself in a sexy position lol). So he walks in, and I guess I scared him (bc he didn’t know I was in there) so I said sorry, and he goes “it’s ok” and walks back out to the living room. Spent 5 more min waiting until I realized he wasn’t coming back then got pissed. Blew out the candles, threw on a tshirt, and went to bed. I was feeling so rejected and humiliated. He walks in a few minutes later and knows something is up because he notices the candles that have just been blown out plus I’m barely talking. He gets in bed and puts his hands on me and feels the lingerie and goes “were you wearing this earlier?” I go “didn’t you see what I was wearing when you came in??” He’s like “no...” So I mutter “I was wearing something special but it was stupid so forget it.” And then he’s upset that I’m upset and that he totally missed what I did and he’s really upset that I keep saying it was a stupid idea. I kept saying it’s fine, bc I know he didn’t do it on purpose, but it took SO MUCH NERVE for me to do that and I was so nervous. I’ve never done ANYTHING like that for someone before and I’d been looking forward to it for weeks. He apologized again the next day. But I don’t know if I ever want to do it again...thoughts???