The worst thing is for it to have no traffic. It turns brittle and loses its flexibility. Traffic "works" it).
And what are the quickest ways to deter traffic?
1. Charge usage fees
2. Impose security requirements and procedures that are inconvenient and are not justified by the risk.
On 1, note I did not say "landing" fees. There are aerodromes out there that charge fees if you merely put a
plan in the system to fly there, even if you never fly there
in fact. And that includes not even flying in the vicinity of the place, much less overhead or landing. They've just set up software to match filed plans to regos and produce a usage charge. I then have to dispute the charges.
As a consequence I will never go to places like YTWB, YORG, YGLB (and I could go on....) ever again.
You could also look to more innovative ways to use the infrastructure. Places like YWWL and YCTM rent out a runway for things like classic car club events.
By the way: Are you aware of any public hospitals, public schools, public bus services etc that turn a "profit"? What, precisely, do we pay taxes for? General Aviation has been scammed into believing that it must grow its own bowl of rice and that's all it deserves.