Can someone explain the endgame for the OT Jew?

Or even a modern day Jew
Or a Messianic Jew

I have a basic understanding of Sheol, a good side and a bad side seperated by a large chasm,

But…specifically…who goes where and why?
Good Jews>Bad Jews>Good Gentiles>Bad Gentiles?

And I understand there is some sort of resurrection? At least one? As mentioned here in John 11

“23 Jesus said to her, “Your brother will rise again.” 24 Martha said to him, “I know that he will rise again in the resurrection on the last day.”

She’s obviously not worried about Lazarus’s final destination.
Was this because he was a good God-fearing Jew?
or is there something bigger going on?

Thanks to all.