Kid Rock declared a Bud Light boycott. CNN visited his bar