The way I see it, it's just an occupational hazard.. Of course no airline will like the inconvenience, but if it an airport has a strong customer base, they will probably weigh up the risk. BRS and LBA have grown quite significantly over the last ten years or so.. Despite in Leeds case of an airport with a far better diversion record being only 30 odd miles away..
CF will hopefully grow to be a good GA airport, and (from a selfish point of view) hopefully attract the likes of Multiflufht moving some of their flight training arm.. But there is no hope of seeing passenger services there in the way that some people might want..