Pictures have revealed the current state of a largely unused Swindon road that cost tens of millions to build.