How does the Canadian Opera Company end its 2023-24 season of high calibre singing and vibrant productions? With a bang, not a whimper.