You asked

how does the new testament's understanding of resurrection and the afterlife compare to sheol?

Reading with you…