The musician is a first-time performer and nominee at the CMA Awards, competing for New Artist of the Year and Single of the Year for “A Bar Song (Tipsy)”