If nuclear weapons grant super power status amongst nations, then Russia is doing everything in its power to reduce its ability to maintain its current nuclear capability. The Russian-Ukrainian war is a bigger threat to a neo soviet union than any border dispute (think annexation of the Russian populated crimea) with a nato nation or a neighbour of a nato nation. Russia has excellent military logistics within their country thanks to their military rail network but they have none of that outside Russia. Putin is sending the precious weapons that Russia needs to defend itself against NATO into a war zone where they are left behind, towed away by tractors and then destroyed by the cheapest weapon that can do the job.
If one were a believer in the neo soviet union nonsense, then this entire war is getting Russia further and further away from that goal. The west can't fight on Russian territory, it can only fight proxy wars in buffer nations by supporting those nations with weapons and training. The only way to explain this is that Putin has ambitions that will only benefit himself and a handful of people close to him. Either that or he is so incompetent he could never win any wars whatsoever.
I sure hope Putin is an evil genius because if he isn't I can only say "Say goodbye to your super power status, Russia, and enjoy your hard fought international insignificance!"