When I told my husband my fantasy, he stopped making love

He stopped making love immediately and says that he no longer feels the same way about me. I am hurt and embarrassed and cannot see a way out of this situation. He is refusing to have any physical relationship with me and is frosty with me in day-to-day life.
He must have presumed that his request would elicit something romantic, or even geographic (the Mile High Club), but he clearly hadn’t anticipated you taking charge. And you obviously didn’t realise that the minute you air a sexual fantasy it acquires a real-world significance that can not easily be retracted.