Would this be good to prevent corrosion of the copper threads of a screw that carry current between two copper pieces?

Yes, this would work for that application. Just apply a small amount to the screw and when you tighten it down the compound will fill in throughout the threads. Hope this helps!