“I’m still in disbelief,” the country musician shared about being tapped for the soundtrack to launch the OG artists’ new drink