Sterling has a tad bit of copper in it that is very reactive, meaning that it reacts to chemicals in the air. Sulfides cause the most reaction, and sulfides are a class of byproduct of tobacco combustion. (internal combustion engines also give off sulfides).
On jewelry, the oils from wearing them next to our skin slows down most tarnish, so the more you wear it, the less it will tarnish. But, on a pipe, it's just going to tarnish, regardless. a microcrystalline wax, like Renaissance Wax, is great for temporarily preventing tarnish... until it wears off with wear. But, as soon as the wax wears, the tarnish will come.
I have been replacing sterling bands for guys at The Briary for a few years, with bands that have a texture to them. Texture makes the tarnish interesting as it wears off of raised parts and stays in the recesses, giving an antique look with interest. But, other than using gold... there's not much you can do that will permanently prevent tarnish.
But, to fanatically keep a band polished on a very thin band, will wear it away quicker than you'd think. Better to try wax, or just polish the bands when they have tarnished to an icky point. IMO.