Not at all. For example here is a picture comparing mine and my wife's surnames. https://i.gyazo.com/f67aae30e098a5f9d1e13fdf58f638e4.png

For (very) common names, yes. Checked mine and a few other rare ones on the German map and it 100% matches the few people I know of, or the region where they hail from.

Even for very common Dutch surnames like Jansen, Smit and De Vries you see interesting differences.

In my case not, I have a pretty rare last name. The map does show it's heavily regional with just a few scatterings elsewhere.