Dogs howl at sirens because of their instinctive link to wolves.
To a dog, that sound is coming from another dog off in the distance howling and he is just being polite by answering the other dog's call.
High pitched sounds on your TV or from a musical instrument can also produce a howl from your dog.