I would prefer to assume governments are somewhat rational actors, who at least try to act in the interest of the own country.
In this case, the biggest loser from destroying NS1 and NS2 is Germany, second-biggest Russia and the rest of the Europe, sorted descending by the dependency on Russian gas.
As for the winners, we have the USA and Ukraine as biggest immediate winners, and indirectly and in the long-term India, China, Arab countries, ...
Let's say secret negotiations are ongoing (it would be surprising if they weren't) with Russia regarding a winter ceasefire. Russia annexes the occupied regions to force the hand and be in a better position, then offers gas in exchange of no NATO military help during the ceasefire.
NATO rejects the offer and blows the pipeline to show it is off the table.
I don't think Russia had interests in doing it, unless it is for some internal power play.
edit: or plausible denial when they won't send gas to Europe this winter. But do they even need the deniability at this point?