Don't underestimate Russia but don't overestimate them either:
Russia lost against Afghanistan already back when they were a superpower and had Ukraine on their side.
They will lose this time too even if they are even dumber this time and choose to waste all their conventional forces there.
The mujahedeen fighting Russia in Afghanistan also had Western (US, particularly) support.