“Honored to have done this with one of my best friends in the world,” musician says after replacing Moreland with J.R. Carroll on The Great American Bar Scene track