The opera singer and star of Go Compare's ad campaign has apologised for his "inappropriate and unacceptable" language.