I think you may have misunderstood me. I appreciate that once a transaction is confirmed on the blockchain, then it is there forever. My point is that nodes are in control of the mempool, and not the blockchain, and so if a large number of nodes run software that excludes certain transactions, then it will make it harder for those transactions to make it into a confirmed block. Of course a rogue miner who finds a block can add that transaction onto the chain. He is then dependant on other miners building on top of his block.
Well that is exactly how Bitcoin has been working for as long as the "standard rules" existed. Nodes don't relay valid but non-standard transactions which makes propagating such transactions nearly impossible and only a miner that is willing to manually include it in their candid block can mine them.
Here is an example of a valid but non-standard tx no node wanted to relay and no miner wanted to mine:
https://bitcointalk.org/index.php?topic=5192454.0Bitcoin knots is just adding more non-standard rules and if a miner mines any of such transactions, it still won't be invalid chain and other miners should build on top of it regardless of its non-standardness.
BTW this is not censorship, and in fact it is a very positive thing that has kept the network clean for years. The only thing people don't seem to agree on is what should be non-standard after the Ordinals Attack began!