Refers to a person or thing that destroys, or specifically a type of warship. In Japanese, it is often used in the context of naval vessels or as a dramatic term for someone who ruins things.
That warship is a type of vessel called a destroyer.
He is a destroyer who ruins the team's atmosphere.