No, this road was not named for the song, and the song wasn't written about it. It's called Copperhead Road because of all that copperhead snakes that have been killed, in the area. This is the road furtherst away from the main town, houses far and few between, separated by thick woods and a few clearings here and there.