We have exactly that in power right now. Putin wasn't rational before, and now he's at risk of losing power. I think it's more grave than anyone wants to admit.
He's an animal backed into a corner. It's not 'russians' calling the shots here, it's one Russian who is unstable and making very poor tactical decisions.
On many occasions in history, wars have stopped because too many people in the military decided that their political "masters" were too insane to be obeyed. We can hope that this pattern would repeat itself.
If Putin can single-handedly cause the rockets to launch then your fear is possibly rational. However, if there are any other people in the loop at all then Putin is unlikely to convince everyone else to commit murder suicide on the entire planet.
Russia always threatens the nuclear option so while it shouldn't be ignored by defense agencies it also shouldn't be taken __too__ seriously. In order for the nuclear option to be used over sanctions there would need to be suicidally homicidal people in place from the top to the people turning the keys in the Russian regime and I think that's pretty unlikely. The sanctions can be unwound and Russia can at least recover to the point of getting by if not better, individuals with means can emigrate with their family, all for the price of one humiliating military defeat that is vastly overshadowed by the economic devastation their actions have wrought. I find it hard to think that most Russians would rather blow up the world than take that option.