Clean energy sources are typically the cheapest sources of energy [0]. The intermittent production issue is solvable: At ~150 $/kWh storage, a combination of storage and renewables is the cheapest energy source 95% of the time [1].
The cost of different energy storage methods is coming down exponentially [2]. A combination of Li-Ion battery (short-term), pumped hydro (medium-term) and hydrogen (long-term, i.e. seasonal) storage is probably how to smooth out the burstiness of renewable energy production eventually [3].
When green hydrogen infrastructure is commonplace, the hydrogen can also be used to make synthetic jet fuel and feedstocks for the chemical industry.
[0] https://en.wikipedia.org/wiki/Cost_of_electricity_by_source
[1] https://www.cell.com/joule/fulltext/S2542-4351(19)30300-9
[2] https://www.nature.com/articles/nenergy2017110/figures/1?pro...
[3] https://www.sciencedirect.com/science/article/pii/S254243511...