I know about all the stuff he's working on but even if it all turns out to work the way he claims, it's not going to be able to transport millions of people into space over the next few years.

If we take the next few years to mean a decade from now then maybe will be at a point where extremely rich billionaires can pay to spend a weekend space on orbital reef or something similar. But I can't imagine will be at the point of millions of people being in space on a semi-permanent basis, not within a decade, maybe within 50 years depending on how SpaceX fair with starship, but that stretching the definition of soon a bit far.

Elon musk said that starship might be able to transport 100 people at a time, which is musk speak for 15 people. But let's say it can transport 100 people at a time, it can get to the moon and back again within 6 days, and they have multiple ships so that they can launch pretty much continuously with one launch every 24 hours. That sounds far fetched but it is remotely reasonable so let's go with it.

Assuming we were already at that level of capability to transport 1 million people to the moon with that method would take nearly 28 years to complete. So we'd be looking at 2048 as the date that 1 million people would be on the moon. But we don't have that capability yet so there's also however much lead time we would need to get to that point.

So even if we started now, as in today, it would be nearly the middle of the century before we achieved his goal, yeah that's not Soon™