The general consensus is that it would be the long-term responsibility of governments because governments endure and industry comes and goes.
In Alberta, for instance, an orphan fund has been established for abandonment of oil and gas wells. And something similar has been suggested for any sort of CO2 storage project, that there would be a certain cost per tonne stored that governments would maintain for use in long-term monitoring and mitigation of any potential leaks.