@kmila47 I would suggest adding NRaas ErrorTrap, Overwatch, Traveler, Register, and MasterController. You can find descriptions and download links, as well as a link to a guide to installing mods, here:
https://answers.ea.com/t5/Technical-Issues-PC/Sims-3-Common-Game-Fixing-Mods-Hero-Approved/m-p/9838855#M244208
All the mods except MC do their job on their own, without needing user input; MC doesn't do anything unless you use it to issue a command. I don't know how much they're going to help with your already-borked save, but it's worth trying a MasterController town reset in both the main save (in the homeworld) and the backup (in France). Click on City Hall or the base camp tag and select NRaas > MC > Town Options > Reset Everything.
One other mod that might help is NRaas DebugEnabler. In the homeworld only, NOT in France, click on City Hall and select NRaas > DE > Sim > Fix Homeworld. This command helps sometimes, not always, and it should never be run in a vacation world.
If you can get to Edit Town after adding the mods and running the MC Reset, you can try switching households, or you can try evicting your main household and putting the sims back in the house. If you can't do either, you can try using the MC Make Active command on a sim from a different household.