The 2024 event made a loss of £320,000 due to increasing costs and declining ticket sales, councillors heard