The Black Crowes singer also discussed his prior negative comments about the Rock & Roll Hall of Fame