Ed is good people, and of course gives anything he posts or publishes a degree of canon-feel, as he is the beloved creator of the Realms . . . but he does not own the rights to the Realms, nor does he work for WotC. So Ed's word on the Realms isn't canon, although I often feel it is better than that . . .

At least according to this tweet, anything Ed says about the Forgotten Realms is canon unless contradicted by TSR/WOTC stuff.
I'll also add that the Realms has long been fairly LGBTQ+-friendly. At least as far back as Forgotten Realms Adventures (1990), the independent city of Elversult was ruled by Lady Lord Yanseldara and her "companion" Vaerana Hawklyn. The book doesn't outright call them lovers, but Vaerana is described as Yanseldara's "deeply trusted companion" and they live together in a mansion called "the Ladytowers."