Russia's oil revenue both from the EU and in total has been massively reduced.

Not really. Although Russia revenue from the EU has been reduced significantly, they manage to open up a new market in the East that massively stabilise their gas overall revenues. Russia is nowadays redirecting its resources east and building news pipelines to meet the demand from the East e.g. China. They no longer care much about the EU market.

That was never the intention and totally unexpected outcome of the sanction. They never thought China, India and even Turkey will come to the rescue. To say EU are not affected is an understatement. The EU now has to depend on the higher price gas from the US, Germany had to abandon their green initiatives and go back to coal, and they even have to buy Russian gas at higher inflated price from middleman to circumvent their own sanction - do you really think they dont know they are actually buying Russian gas? Of course they know. But they have to because they will suffer more if they don't.