About this, The current Forgotten Realms material is highly sanitized from the original Ed Greenwood`s vision
https://1d4chan.org/wiki/Ed_Greenwood (One of the original creators of the FR setting). In FR as created by Ed:
Bi-sexuality is normal (and yes, this means the men as well as the women)
"Revels" (sex orgies) are normal
"Festhalls" (brothels) are in every small village and visiting them is normal way to spend evening.
Prostitution is the main industry of Forgotten Realms, "sex workers" are everywhere and there are about 100 different names for different kinds of prostitutes.
Incest is normal way for families to "indulge feelings of mutual affection"
Public city-wide orgies are the way to celebrate major holidays
All of this is confirmed by Ed Greenwood himself, from Ed's responses to fan queries on the Candlekeep forum. It's also all completely, 100% canon thanks to Ed's ludicrously favorable contract; other writers can try to dance around the creepy shit, but they can't outright contradict anything or else the whole setting falls into Ed's greasy, sticky hands.
Sc :Ed Greenwood AMA
http://www.candlekeep.com/library/articles/sse/so_saith_ed.htmIn short, the Forgotten Realms are Ed Greenwood's magical realm cleaned up by TSR and later Hasbro for general consumption, and the Romantic Encounters mod for Baldur's Gate is probably canon.
An attempt to Retcon the massively corrupt and crime-ridden city of Waterdeep into "Seattle during Pride" was actually met with significant backlash.
Since WOTC is involved in the creative process of BG3, we will possibly see something in the Hasbro lines, with the usual content of a D&D adventure.