I spoke with a developer from Rare at one point, and said the game was pretty much complete. It was a sort of on-the-rails shooter. Apparently the base design of the game was pretty much the same as the N64 version.
But yeah, any carts you see of Goldeneye for the snes are undoubtedly pirates.