A sell-out smash-hit summer musical has helped secure the financial future of Cork Opera House for the first time in almost two years.