Not sure why, or how, the horn should go off if the battery is flat?
Personally I would leave the CTEK attached permanently that's what it's designed for.
See if the battery recovers after being on charge for 24hrs, otherwise a new battery and leave the CTEK doing it's job until you want to drive the car.