Last sim of household is dead

What happened:

My last sim of the household died when he drowned do death in the Selvadorada temple thing.

How it happened:

I left him and forgot to pause and he was in the water of the temple and his energy stat went all the way down and i when i came back he was drowning and died. He had high stats and max archaeology stat with tons of items in his inv from excavation.

How i tried to fix:

Last save i could revert to was about 2 hours back and i'd rather not waste 2 more hours getting all that back. I sent some random sim to the exact spot where he died but his path was blocked off by the weeds again and the temple reset with no tombstone thing.

How do i get my sim back?