Sanctions usually don't lead to the population turning on the regime, after all it tends to make the population more dependent on the regime, but sanctions do frustrate the regime's ability to wage war etc.
Primary of primary purposes is to reduce their ability to fund a war. War is very expensive, the reason for war can never be resources these days. These sanctions have certainly put a threshold of this war probably around 6 months.
Putin expected this to be over in 72 hours, he kind of needed it to be over in 72 hours.
The secondary possibility is that the Russian people oppose this and overthrow the government. That would be an ideal situation. I dont think that's necessarily high on what will happen.
If sanctions fail and an accident happens like invading or shooting at NATO. We won't be post-war. We start a world war in which Russia loses... just look how unified the world is against Russia.
This is highly unlikely.
However the coming weeks and months shake out in this war and in the broader political picture, it's important to approach the situation realistically.
This isn't a video game, cartoon or Hollywood movie. The timeline isn't going to be measured in days and the primary agents' motivations and actions aren't as simple as in cartoons.
Pretending otherwise will only confuse you, over and over as events transpire, about why things aren't going like they would in a cartoon.
Also sanctions can be an instrument susceptible to abuses compared to nuclear weapons because it's so one-sided --- there is little point for any country to sanction the US, for example, but a total US sanction would be disastrous for most countries.