Zardnaar
Legend
I think it entirely varies based on your particular campaign.
The upcoming two Forgotten Realms sourcebooks should give us an idea of how these species are viewed "canonically" by the general public in Faerun these days.
WotC had input into how these species were portrayed in Baldur's Gate 3. In that game, drow, goblins, tieflings, and hobgoblins are clearly viewed with varying degrees of suspicion by many NPCs, but they are not greeted with a "kill on sight" reaction.
Tieflings have been exiled en masse from Elturel as a result of racial prejudice following the events of Descent into Avernus, but they don't seem to be having much trouble in Baldur's Gate itself (though they also don't seem to occupy any high status positions in the city; we don't see any tiefling patriars, for example, although there are a few tieflings in the Flaming Fist).
We don't see any goblins living in the general population, even in Baldur's Gate. There is one hobgoblin refugee from Elturel whose admission to Baldur's Gate is being stalled due to his race.
There are a few drow NPCs in Baldur's Gate, who seem to be tolerated. Again, we don't encounter any of them in high status positions. The most negative reactions to drow characters tend to come from Deep Gnomes.
Kobolds are rare in the game, encountered in one remote area as hostile scavengers, and there is one peaceful merchant kobold who is part of a circus whose membership includes many unusual beings. The general public seems more or less unfamiliar with the existence of gith.
There's 1 more Kobold merchant near the end
