There's this thing called the power grid, it transports electricity across great distances.
And everything you're talking about is an issue with any kind of production, I don't know why you're bringing it up as if it's unique to solar. If you're building a factory that needs high amounts of stable power then you plan accordingly. Doesn't change the fact that solar is a useful way to generate electricity. I don't think anyone is saying we have to use it exclusively. We can use different solutions for different problems.
And everything you're talking about is an issue with any kind of production, I don't know why you're bringing it up as if it's unique to solar. If you're building a factory that needs high amounts of stable power then you plan accordingly. Doesn't change the fact that solar is a useful way to generate electricity. I don't think anyone is saying we have to use it exclusively. We can use different solutions for different problems.