The country music star apologizes to fans after he was caught partying mask-less during the pandemic before his "Saturday Night Live" appearance