You asked

what did 'sheol' mean to an ancient israelite when this psalm was written?

Reading with you…