Stuxnet isn't a great example precisely because they never dropped any bombs even though they could've arguably gotten away with it.
It's worth keeping in mind that the pipeline was also pretty much dormant anyway, the official nord stream data has it that flow collapsed around june, down to exactly 0 (by their books, there was still pressure in the pipe) kWh per day by September.
There is criticism regarding the quoted story, the main is that Soviets at the time mainly used analog/pneumatic and manual control systems, not digital software. https://en.wikipedia.org/wiki/At_the_Abyss
But those trades were already shut down and not coming back anytime soon. If Germany had refused to join sanctions and was still using NS1 + NS2 at full capacity right now then maybe there would have been some motivation to force the issue. But why now, when the pipelines weren't even active?
You are analyzing this too much in the short term. These pipelines were meant to last for decades.
The pain of seeing a quarter of your industry close for lack of energy might have easily bent the will of Germans and others after this winter. All political announcements about replacing Russian gas before 2027 at the earliest were a pipe dream (pun intended)for anybody with any actual knowledge of the industry.
Even now, a large portion of what was supposedly bought elsewhere was just repackaged and re-originated at the port of loading, but actually Russian gas - hence part of the price hike going to a chain of middlemen.
https://www.washingtonpost.com/archive/politics/2004/02/27/r...
The U.S. motivation is that it has tried to shut down energy trades between the Soviet Union/Russia and Germany for more than 50 years.