I think that it’s true that promiscuous behavior could indeed be more likely in people who suffer from low self-esteem and that this could be due to a dysfunctional relationship with their parents. Perhaps they’re looking for the love that they never received from their parents growing up. But from what I’ve seen in talking to people who grew up in conservative religious households, including members of my own extended family, these households can be just as dysfunctional as any other and the children in them can also be subjected to psychological and physical abuse which leads to low self esteem.
And sometimes people can grow up in very good families with loving parents and still grow up with low self-esteem because of messages they receive not from their parents or a bad family life but from society or their church. This happens with many people who grow up gay and many of them are indeed promiscuous later in life. It’s not an unhealthy relationship with their parents that has caused them to have low self-esteem, but rather the message from society or their church that people like them are disgusting, defective, and prone to committing unspeakably sinful and abominable acts. And quite often, gay youth struggle with this internally on their own before they come out and even when they have good and loving parents, are afraid or ashamed to tell them.