I'm a church minister and there is always a tension between the amount of money it costs to keep and maintain buildings and what we are called to do as Christians. Increasingly, it makes sense to close older buildings and either unite congregations or to use resources more creatively to build new, more energy efficient buildings which can be shared with the others in the local community. Or share existing buildings - like schools, other churches, community halls etc.
Buildings such as ancient cathedrals which often have a civic use and importance are a particular problem, and I've never ministered in one of these. I do though, think that there is an argument to be made for them being funded by the civic authorities and communities who very often are the ones who most want to keep them open, while being content to let a dwindling congregation deal with the financial strain and burden of doing so.
And yes, it can and very often is a distraction and diversion of resources from other activities. But places of worship are important, for many different reasons - some more emotional than practical, and there really are no easy answers.
In my previous charge, I was based in a visually unattractive, flat-roofed 1960s building which had leaked from the moment it was open, and when I was there, I regularly arrived and spend the first hour or so of my day emptying buckets of rainwater which had come through the roof, mopping up and carefully replacing the buckets.
In that decrepit building, we fed the poor, homeless, marginalised and addicted for free, worshipped with and fed those whom many people would shun, despise or ridicule, helped with and gave rent-free or low-rent accommodation to charities who help and/or are run by people with a range of disabilities and life challenges. We were also actively involved with a local church charity to assist homeless people, and assist those in prison and on release from prison.
Church buildings do cost money to keep, but that doesn't mean that keeping the roof on is the only thing that congregation are doing.