Sanctions have worked to an extent, but I don't believe sanctions can make Russia stop the war. This looks like a war in that the ego plays a very big role. Neither Russia nor Ukraine nor NATO would want to agree that they've been defeated.
Without the sanctions, Russia would have been able to do more harm to its enemies through economic means and otherwise. At this point, they're just looking for ways to survive whatever sanction that gets thrown at them and they've been managing well so far.
You have a raised valid concern regarding limitations of economic sanctions in achieving desired outcomes. Economic sanctions may initially produce some results , but later targeted countries devise strategies to mitigate their impact on their economies overtime, and same thing is happening in Russia Ukraine conflict now.
The Russia Ukraine ongoing conflict has led to heavy human causalities, collateral damage and economic difficulties all over the world. We should raise our voices to exert pressure on political leaders to find effective ways to bring this devastating conflict to an end.