story
Absolutely, but then just one of these things will dwarf the ISS all on it's own. The old equations of space exploration affordability are being rewritten.
As for people wanting to go, there's a permanent base at the south pole, the peak of Mount Fuji is often a churned up field of mud from all the visitors and Burning Man looks like a ton of fun. Ok so some of that is frivolous. I'm ambivalent about the idea of Martian cities in the next 30 years say, but who can really look further ahead than that?
There's nothing that seems un-achievable about BFR. It seems to me these things will be going to space, and the Moon, and Mars at a ludicrously low cost compared to previous space missions. The real question is what will we do with that capability? I'm guessing we are going to do something with it. Musk's graphics are explicitly aspirational, but we'll do something with these vehicles and its going to be a heck of a lot more than any other plans I've ever seen.