I will always associate pipe pigs with the opening scenes of Living Daylights where they exfiltrate a defector through a gas pipeline. Ridiculous but memorable.
I think that was Sean Connery in his swansong as Bond.
Diamonds is a flawed movie and one of the weirdest Bonds, but it's my favourite because it's so weird.