I never played TWINE, but I've seen some videos and stuff.
I think that it never outshined GoldenEye because GE was not only the game that brought a complete revolution to consoles but also because it was the first movie-to-game conversion that actually was good (too good in fact). GoldenEye was pieced together with mastery; from the levels to the weapons, everything fit in GoldenEye, even the NPC animations. It became a classic and it is very hard to beat a classic. People still wanted GoldenEye because it was taken in such high regard and it was made by Rare. TWINE wasn't made by them and given the fact that the last successful Bond game had been made by Rareware, perhaps people though a bit low of TWINE.
That was my opinion on the subject. Hope you liked to hear (better, read it).