You asked

what did 'heaven' and 'sheol' mean to an ancient israelite, and how did that inform god's presence?

Reading with you…