I think what children need more than anything else are stability and security, they should ideally be able to see those things in relationships as well, whether it's cis-het or otherwise...kids pick up what they see, for better or worse - one who spends 20-ish years around loving caring adults is going to pick that up