Thanks for looking into my game save for me.
After some thought I came to a solution and I've tried it and I think it's the next best thing. I cloned my current sim (the one with the bug) using the cloning machine from Get to Work (which was already in my house as I'd done the scientist career) and i renamed the clone to the same name as my current sim, then used cheats to make the skills at the same level as before. The cloning method also keeps all of the same traits and reward traits so that's even better as I had quite a few. I then deleted my old sim and have replaced her with this identical copy, and because I deleted her the "husband" is none the wiser. I'll just get their relationship up and get them married and the world will never know! Then overthrow the clubs I was previously leader of but that's not much of an issue 🙂
And of course I've tested for the bug and it's all fine! The moodlet no longer exists yay. I will take them on vacation soon and test it one final time and if it never comes back then problem solved.
Thanks for your help