You will literally never see the sky “like this” anywhere. It wouldn’t even appear this way if you were literally in space with no surrounding atmosphere. This is the result of a very long exposure time along with a bit of work in photoshop. I hate how these pictures are presented as if someone literally is suggesting they just drove out to some remote area and saw this upon looking up.
You can see the Milky Way in remote areas with low light pollution, but it’s very faint in comparison to what this post suggests.
Here is an example of what it looks like to the naked eye. Naked eye on the left, extra exposure time on the camera on the right.