There are two types of break in, broadly speaking. The people who want to sneak in, quietly ransack your house for easy-to-lift electronics, cash, car keys etc, then make a speedy get away. Not likely to go into your room solo, or seek conflict, but realistically likely to be fitter than your average homeowner. If it comes to it, they'll either run when they see you- which they'll do if you have a weapon or not- or use whatever level of violence they have to to escape. My dad was knocked to the ground by burglars like this- they didn't want to hurt him but he was standing between them and the door. I honestly think if he was carrying say a baseball bat they would have given him a thump with it on their way out.
The other kind is the home invasion, people who want certain things and are prepared to threaten and injure to get them. Sadly know people this happened to- they run a business and the assumption was they'd have a safe. They were threatened, tied up, and lightly injured. Again, if they had tried to resist, I think they could have been killed.
I have a phone by the bed and a bolt on our bedroom door, as well as all alarms being on and security lights front and back. There is no way I would allow a weapon in our bedroom- seriously: you're confused and half asleep and naked, they're pumped full of adrenaline with eyes adjusted to the light and a fight or flight instinct. Even if you were a ninja you're starting out at a huge disadvantage in that situation, and you don't know if they have another mate outside the door.
I agree a large burley husband might make people run away (and I'm lucky I have one of those!) but I'm under no illusion a weapon would do anything other than raise our likelihood of being seriously injured.
I think all the people who imagine they can overcome an intruder are kidding themselves, and in some cases potentially opening themselves up for prosecution (oh yes the pepper spray was by the bed as I like to season my weekend eggs on toast with it.....) I'd rather spend those seconds ringing 999.