You asked

how did ancient israelites understand 'heaven' and 'sheol' in relation to god's presence?

Reading with you…