Just replied to someone else who asked pretty much the same thing so I'll just link my answer here. Short answer though is you can't see it looking close to anything like that, but can still make out quite a lot of detail if the skies are dark enough.

https://www.reddit.com/r/EarthPorn/comments/y3ssbt/milky_way_core_over_la_palma_oc1017x1600_astrorms/isatf4n

You won't see it looking close to that anywhere. The long exposure and subsequent editing brings out a ton of detail (and colours) that it's just not possible for us to make out.

Just googled it and reckon the photo at the top of this guy's page gives a pretty good representation of what you can see, which is still pretty awesome in my eyes (although not literally because there's terrible light pollution where I live!!)
https://www.nightskydan.com/seeing-the-milky-way-naked-eye-vs-digital-camera/