This is because gods in that universe derive power directly from the number of people woeshipping them, right? So, yeah, the goddess of farmers makes sense as one of the most powerful, because there are a ton of farmers out there.
I’m not particularly familiar with the FR pantheon, but I would imagine a god/dess of death would prove quite powerful, particularly if people don’t just pray to them during a funeral rite, but also as an homage to deceased ancestors. Also, a deity of trade (which I’m pretty sure FR has—is it Waukeen?), as trade is very important and there are doubtless plenty of merchants and trade guilds.
While I think this is definitely true, there does seem to be a notable exception to that in Bahamut and Tiamat, right? They're both pretty powerful deities, but unlike other deities, their own races don't actively worship them.
There's probably some obscure lore in there that I don't know, I suppose.
Well, think about it. Agriculture is civilization. Farming enables cities, specialization, and large-scale cooperation. Without it, we're tribal hunter-gatherers.
I love "obscure" gods being ridiculously powerful in some specific regard. This has roots in reality; the Roman god Janus was seen as the bridge or portal to all other gods and was thus invoked first in all religious ceremonies, even before Jupiter himself.
I mean, think about how many farmers have turned into level 20 John Fighterman. She's got an army of level 20 souls who can all attack 8 times in the first couple rounds each.
I mean yeah it makes sense. Agriculture is the foundation of sedentary civilizations; in a medieval world like FR the vast, vast majority of people would be farmers; and without food everything else just falls apart.