These Honda's only switch on the ground wire.
Typically horns with two terminals either switch ground or hot. If yours was meant to be grounded to the frame, then why are there two terminals on it?.
Throw it away.
Connect a meter to the green wire and the frame, you should only get continunity when the button is pressed, and your black wire should be live all the time with the ignition on.
Most horns are marked with + & -, if your wiring check is OK, buy a new horn they are cheap, If not go find where you threw it.