I'm having a similar problem - I can get past the load screen but not into any households, even if I manage to make it to the map after the initial unsuccessful load.
I've spent two hours doing all the usual fixes: restarting steam, EA, and my laptop, removing all mods, loading old saves, deleting all the cache files, repairing EA, verifying the file integrity on steam. at first i thought it was this household specifically, because this has happened before with them (it fixes itself usually idk), but i tried four different families in three different neighborhoods and two townie families 😭
I'm a little nervous to try deleting save files, but I may try it if they don't update soon. I'm really glad it's not just me though, I had no idea what else to try!
Update: I copied all my save files to the desktop and moved only three files back (one save with two of its most recent versions, which turned out to not even be my legacy family lol) and it wouldn't load either. I managed to get into a lot by removing my Sims 4 folder entirely, but that doesn't really help. It's also stopped jumping me to the map, and I feel like the more I try to fix it when it's an EA problem, the less it works, so that makes me think even more that the problem's on their end. I was going to settle for building tonight, but now it won't even let me on the map lol