As long as it doesn’t end up like this: youtu.be/lfyaftYvFGg

Sounds like a can of worms. A soft spot in the floor probably means the subfloor needs to be replaced, and if the floor joist is also rotted, then you’re really up a creek. I say just sell the house and move to an apartment.