A landmark church in Cork City is at risk of crumbling unless it receives an urgent cash injection.