No, that's no given, and likely more to the not a given at all territory. Why? Because the drunkeness and absuiveness of the Dad can be explained and self-explained in restropective contemplation by the child as a know vice. Everyone knows drunkeness and abusiveness is vile and to be avoided.
So the child, once grown into adult can put all the evil of the Dad behind him because it is know as the evil it is to all, and all sane parts of the culture reinforce that wisdom.
Not so with the lesbian mom, or the homosexual dad. Our society has become ambivalent or even welcoming of that perverted state.
Without the social framework that calls a lead weight of bad and lowly behavior the lead weight it is, many and most children will find it difficult or impossible to come to grips with it. They are burdened -- hobbled -- by the necessity and naturality of attachment to the parent no matter how perverse that parent's behaviour, when society telles them that behaviour is tolerated and even celebrated.
You would have those children chained with unbreakable hardened steel chains to the heavy anchors of the sins of their parents.
See my 702 prior.