Well, the Church has made the decision to become a queer Church. Don't see that that will be changed. Unless drastic action is taken (doubt that it will), your children are growing up with many, many homosexual (who are mostly actively homosexual) priests. Just don't leave your sons around any priest.
Our church left my son a long time ago and our church is driving my daughter away out of fears for her son and fears of the Criminal priests who are leading the faithful astray. My son in law just became a Catholic about a week before the current Crises created by Cardinal Law Hit the Fan,can't imagine what he is thinking...