A 41-gun salute to mark the anniversary of the Queen's coronation has been cancelled after a horrible injury to a horse.