I've heard 2040 (note this is not 2030), 2029, and 2027 for 'back to normal', 'new production online', and 'potentially a lower demand will be seen and still not enough supply', respectively. All hearsay from me reading news headlines.
Global inflation and f&&&ing Dump will impact all this ofc.
Which it to say, if models eventually do useful work, demand for substrate will continue to outpace production. I don’t envy the fabs that have to forecast how much memory the world will desire in 2030