The Welsh opera singer issued a statement as he apologised for an “inappropriate and unacceptable” comment