No. Not just a name. The road really exists and it is the one that Steve Young had as inspiration for the song. Wikipedia tells the story as a quote from Steve Young who lived in Montgomery in the 60's.
The roadsigns (Montgmery City Limits and Woodley Rd) confirm that these really are pictures taken from a drive down that road.
It's for real. These are not "just some pictures" I found on the Internet. They were taken by a friend of mine who has local knowledge of the area.