I have two 30-ish kids. Neither knows. They both live in different states so "accidentally dropping by" isn't an issue. I came out to my wife when she caught me when our oldest was about 3. She told me to never let him see me "like this" as it would destroy him. He's probably the most liberal of the family (voted for Democrats???).
I have thought about it. My kids grew up seeing me as the beer brewing/drinking hockey coach who lived for great outdoor adventures (alpine hiking, fishing, remote camping ...) I would hate to lose that image with them. Since I am an occasional dresser at best I don't see the need.