After years of playing rpgs, I've long since come to the conclusion that the best way to enjoy the game is to turn off the brain and not think too much about the sense of the plot.
Works almost every time.
Certainly for Forgotten Realms RPGs.
Acting like BG3 is unique in scuffing FR lore is disingenuous. It was utterly contrived, stupid and retconned during BG 1 and 2 as well. The Baldur's Gate series are RPGs that stand irrespective of their source material and succeed in spite of Forgotten Realms being such a silly setting.
I could care less how much Baldur's Gate 1, 2 and 3 all violate the Dead Three and their schticks, I care not about Baldur's Gate the city, I was slightly annoyed by BG 2's lazy portrayal of Amn, but that was back when I still gave a shit.
Really, the Baldur's Gate games (1 and 2) and then Oblivion later on were what made me stop caring about lore in video-games and fantasy in general.