No, it doesn't look much like this to the naked eye. Even in very dark sky areas, the Milky Way looks a lot fainter than this and the colors are basically invisible. Here's a photographer simulating what it would look like, and that matches my experience.

On the other hand, time lapse night sky photos never do a good job capturing just how many stars there are far from the cities. It's wild, and everyone needs to experience it.