Actually, few cities and towns in Germany still have these. Many (if not most) were taken out of service since the mid-90's.
This is the sound that no German ever wants to hear, particularly not those who remember the Cold War:
Imagine (unless you experienced it) to hear it on test run with a test signal sequence, knowing that you live at the frontier of NATO during the Cold War, expecting to simply die within minutes, hours or days after hearing that signal above - regardless of what you do or our soldiers try. It would make no difference between getting killed by a red or a blue bomb.
The perception as I remember it wasn't that "only" a million or two of us would die as simulated since the 50's, but more likely pretty much everyone.
It's been a quarter century already, and I wonder by how much the collective memory has faded and will fade.