There are East/North European member states that are genuinely concerned that Russia could attack them next. They advocate for stronger sanctions. And while it's not said aloud, they believe the sanctions should be in place until there is (at least) a regime change in Russia. For them, the real issue is not the war in Ukraine but Putin. And if the economy crashes as a result of the sanctions, it's a small price to pay for safety. That's Realpolitik for them.
Then there are West/South European member states that are safe from Russia and mostly just see the economic consequences of the sanctions. They are economically stronger and have more political influence. But if they try to force the issue and lift the sanctions too soon, it could well be the end of the EU.