I don't think most D&D settings actually propose that. There are mentions in lots of settings that the chosen deity is merely the one that gets your soul, but people pray to whatever gods that apply to their situation.