You asked

how did ancient israelites understand 'sheol' and god's presence there, compared to other deities?

Reading with you…