I have to come in here because it's depressing reading all these disaster stories.
I told my wife about 18 months ago after many years of marriage. I picked what I thought was a good time (not on holiday!). We went very slowly with the process of showing Ruth to her, and she was rather hostile at first, but she came to realise that Ruth is just one facet of me, and she still had her man as well. Now I can dress around the house pretty much when I please, with my wife enjoying the show and quite often complimenting me on my outfits.
My dressing has resulted in much more emotional open-ness and a generally sunnier disposition, and so our relationship is closer now than before.
So please tread carefully, but also please believe there is such a thing as CDing within a happy marriage.