Its only canonical use is in the last mission of the Soviet campaign. It was used repeatedly due to the fast loading time not seen in Skirmish.
It technically destroyed the entire Allied base and their units but it still wasn't long-ranged enough to destroy the place the reinforcements were coming from.
The Nuke can be used by Soviet players in Skirmish. It loads slower than the one in the campaign but it still has the power to destroy whole bases.
It is stronger than both the Allied Weather Storm and the Imperial Psionic Decimator.