Sherry, in my own (somewhat limited) experience, social workers are usually very supportive. They have huge caseloads, and they’re normally delighted to sign over responsibility for a child to a good family. They’re too busy and overwhelmed to worry about objecting to sexual orientation or anything like that.
Also, the bulk of social workers have degrees awarded by progressive universities, so they’ve at least been exposed to ideas about diversity that may fall outside their personal experiences.
It’s really the private agencies where problems come in. Most agencies are willing and able to fulfill the terms of their state contracts, but with Trump in office and overt homophobia on the rise, more and more of them are emboldened to seek legal permission to discriminate in the name of religion.
The Catholic Church has done a masterful job of propaganda. Pope Francis says plenty of difficult-to-interpret, halfway nice things about LGBTQ people, while the institution he leads continues to spend millions and millions of dollars in lobbying and legal fees as they pursue vicious policies and campaigns of homophobic bigotry.
And people buy it!