I don't see how Stalingrad is a good example for this war because well, first of all Stalingrad is a Russian city and secondly, the Germans lacked proper technology and logistics to endure cold Russian winters in 1940s.
Anyway, why would Russians want a revolution? The only reason that Russian people may want a revolution would be for better economic conditions. But do you think the Russians would sell their country to the West for temporary improvement in their economic conditions? Do you think Russians, being one of the largest empires of history, do not have the vision to understand that sacrificing their national security will not lead to a better future for them?
Also, you are assuming that the problem is Putin. But this may very well not be true. Russians feel threatened by NATO's expansionist policies and they have felt humiliated for far too long after the dissolution of the Soviet Union. It's not like Putin didn't give diplomacy a chance. Putin could've done this back in 2014, but back then he hoped that the West would accept him as an equal and give Russia a share of power in global affairs without a need for military confrontation. The whole concept of tandemocracy in Russia was about cooperation with the West instead of confrontation. Instead, the West continued to disrespect him and interpreted his patience as weakness until this happened. Putin has made the decision of invading Ukraine fully aware of its political and economic consequences and the majority of Russians seem to agree with him. Hence, I do not see why a patriotic revolution is necessary and how it can change the situation for Ukraine or the West, if not make the situation worse.