I hear you and it would be nice if we could go back to that but it's a nice dream, not reality. I think we've discussed this before. The old model you are talking about hasn't worked for decades. Scouting needs a total corporate restructuring that re-engineers the structure around serving units to deliver the program in the field. It needs more professional support if anything, or at least professional support that is refocused and redeployed. Where will the money come from? I don't know, but that's what a restructuring would start looking at.
Adding paid professionals isn't an option. For every paid professional you add to a council you have a direct dollar-for-dollar transfer away from program.
Nationals model of helping councils is grant based. Grant based headcount is inherently unstable and unreliable due to the come-and-go nature of grants.
There are no employees to send to the councils to help either. National has around 700-800 employees total depending on the moment. Most of those employees are high adventure base staff (EG: Todays news reports on the Northern Tier evacuations is that 200 staff are being evacuated along side any remaining scouts on trek). The math is that national basically puts ALL OF ITS MONEY into staffing program a the high adventure bases and the Irving office is basically empty.
If districts and councils don't lean hard into recruiting volunteers they will cease to exist, volunteer based councils are the only way forward.
That won't return, not least of all due to liability issues. Scouting needs to evolve into an organization that is able to offer more paid professional support to unit level volunteers so that they can deliver functional, safe, consistent programs or it won't continue. Maybe you'll still have a few vestigal hubs of nostalgic activity around high adventure locations or some of the larger council camps, but it won't be able to function nationwide without some kind of support.