These data make it plain that crises are local and are rooted in things other than a requirement for celibacy.
The fundamental truth is we need less priests today. I know we hate to hear that, but it is true. Prior to the 1960s, nearly 80% of Catholics attended Mass and the other Sacraments regularly (confession). Today that number hovers a little above 20%. That is a 75% decrease in the number of faithful who regularly participate. It would follow that as a result you need less priests to serve the community and less bishops (I can think of a few cuts). The same goes with parish consolidation, you no longer need the Italian, German, Polish, and Irish Parish in the same small community.