I'm just getting into wood burning as an adult, but the rule of thumb I've heard is that you need about one acre to sustainably produce one cord per year. So if it takes 4-5 cords per winter to heat your home with a newer gasification-type burner, then you'd need to be in an area with an average lot size of 5 acres to consider that sustainable. That's decidedly rural, but practical for many, especially with even better insulation. Save the higher density, cleaner burning energy sources for places with denser populations and shared walls. Although unfortunately with nonsensical zoning policies, city buildings tend to be older and poorer insulated.

Obviously we'd be better off with heat pumps run by renewable electricity supplying most heat. But lack of storage seems to be the missing piece right now - peak solar production and peak heating load are on opposite sides of the day, unlike air conditioning. Nuclear would be capable of generating electricity at the right time, but it's presently stalled for many reasons. But even if we had widespread nuclear, that wouldn't help from the individual perspective of still needing a heat source during a power outage.