The singer-songwriter says he wept the first time he heard the fully produced song that features Lainey Wilson