No one will deny the top two powers are super powers. Rome and Carthage were super powers of their day. Greece and Persia were super powers of their day. Britain and France were super powers of their day. America and Russia are super powers of their day.
I'm not sure there are usually 2 superpowers in the world, the situation with the Soviet Union and the USA was the exception.
To be a superpower after all you need pre-eminence which precludes there being a peer competitor around.
The definition of a superpower requires also world wide power projection which was only possible when you have globe-trotting blue water navies, say from about the 15th century onwards. It's ready hard to see why even a power like Rome could have been seen as a superpower when it didn't even know a large fraction of the Earth existed. It was more of a regional power.
The first true superpower was probably Britain from about circa 1800 to 1900. Before that it was a "great power" situation where lots of competing peer powers were vying for dominance.
After the decline of Great Britain, the world's only superpower, we went back to a great power situation, with disastrous consequences as we all know (world war 1, and then world war 2).
It was only after the emergence of the USA and Soviet Union (SU) that a period of relative peace has occurred. The USA and SU were both the unqualified rulers of the world - nothing happened without their permission.
By 2030, most pundits expect the USA, the last remaining superpower, to lose its superpower status. We then go back to a great power scenario.
The great powers will be the USA, China and perhaps India or a united EU. All competing for dominance but none powerful enough to impose hegemony and thus achieve superpower status.
It's actually dangerous not to have one country that is completely dominant. Two superpowers are better than one, but one superpower is better than none. History tells us that without a dominant world power to hold the international order in place conflict will break out.
As to Russia's future and present, well it's power is much over hyped around here. It's at most a "great power" with a very weak economy and that makes it vulnerable. It has no global power projection and even its regional power projection is severely limited due to its economic weakness. It simply can't afford, literally, to confront its much economically stronger geopolitical opponents in the EU or US
Russia will only get weaker. It's in relative decline with the rest of the Euro countries.