You asked

what might 'sheol' have meant to the psalmist's original audience regarding god's presence?

Reading with you…