I had similar issues with these horns.
My experience is that they get stiff from old age and disuse
Some of them hem I got working y jolting them with 9v as you have I’ve done it a dozen times or so for 2-3 seconds it not constantly I take a break after 4 times to make sure the coil does not overheat
I had all but one return to working with 1.5 V
make sure you test directly to the horn and not through the relay so as to have on less item to worry about