The article doesn’t go into it, but a key advantage they have is that heat pumps move heat, rather then trying to generate it. So they can move a lot more heat into your house than would be generated by running the electricity they use through a resistor. This makes them effectively more than 100% efficient (the exact amount depends on temperature) as compared with burning a fuel or resistive heat.
He mentions that his parents live in a single family home in the same area and get along fine with heat pump.
Plus, from personal experience, the heat pump in my SFH only started needing emergency heat when the 20 year old compressor started to go, and since I’ve replaced it I’ve never had to use the emergency coils. I do have a fire in the fireplace on very cold nights, but that’s mainly to alleviate strain on the grid.