I usually keep quiet, but this is setting of major alarm bells.
He sounds just like my narcissist controlling ex, and this is how it started for me. Even down to having two children that weren’t his.
He doesn’t want you to work so he can keep control of you, your thoughts and how you spend your time. He is upset that you went out with a friend and had a conversation about finding work. The problem here is that he has you thinking you have done something wrong (that is perfectly normal human behaviour) and that he is threatening to leave you so that you feel the way you are feeling. The outcome of this will be that he definitely won’t leave you, but you will never do anything like this again in fear of him leaving. He also will be feeling uncomfortable that you have brought up the issue that you would like to work with someone outside of your relationship. It makes him look like he is being controlling and he won’t want it to look like that to others, I’m betting he makes a show of taking care of you all. Im also betting you don’t have much access to finances and feel bad to ask for anything.
I spent 6 years being treated like this, and it only got worse. He chipped away at every part of me to the point I was a shell of my former self. He had me believing I was weak, couldn’t cope with life and had me tal health issues relating to past trauma which he used as a stick to keep me in check with. Actually was the start of his downfall as my GP referred me to therapy, and as I worked on myself I started to question the lofe I was trapped in. In the end I left our (his) rented house and was rehpused by the council. I now have a professional career, my own home and after leaving and my lovely girls also needing therapy we are thriving. He affected all 3 of us so badly, and ill never forgive myself for my girls having to suffer through it all. For the first 12 months he was perfect, and caring and everything I’d ever imagined I wanted from a partner. He was clever, and manipulative and I feel for it all.
The issue here isn’t that he will leave you because you have told a lie, the issue here is that he has you believing this to be the truth, where it sounds to me there are much much bigger issues.
Please tell him that he should leave if its upset him so much. You are looking forward to starting your new job and wish him well. Then congratulate yourself for freeing yourself from a pathetic excuse if a human being