I have no kids, so it changes my view, but I go every year during Gay days, due to a work conference. I've never seen anything that would cause problems for anyone, unless they're desperately searching for it.
It is, however, best to avoid MK that Saturday, and I'd avoid PI on Friday night and Saturday night. I'm of the crowd that believes PI can be a fun experience for a child, but this is one place during Gay Days where you may end up having to do some explaining.
Beyond that, I find it to be a normal visit to Disney. The Gay Day participants tend to be young, which means they tend to be loud, but it's not a heck of a lot different than Spring Break.
Pat