"I realize that what I said hurt people and that was not my intent. I sincerely apologize to the transgender community and everyone I offended," the famed guitarist said.