I don’t know the exact number of affected projects, but the fallout I am comfortable attesting to is that the longer this stays in place, the more investment sits on the sidelines to see how it shakes out. A project that could have been approved during the freeze would most likely be online by 2030. Possibly at early as 2027 depending on what stage the project was in at the time of freeze.
As Hate mentioned, there are projects that have dollars already invested that are affected by this. Land purchased, contracts entered into, gas committed, pipe committed, etc. Upstream and midstream companies will now pull back on commitments, investors will want to wait before committing money to feasibility and economic analyses, land that would have otherwise been acquired in prime export locations may get purchased by other industries, and overall money just goes elsewhere and it most likely isn’t to green initiatives.