the oil market is really resilient and would require more than just a small guerilla war (essentially) to become unprofitable

Destruction of fossil fuel infrastructure won't necessarily make it less profitable (particularly for surviving pipeliners). But raising the perceived risk premium can shift all sorts of investment calculations, especially during periods of higher interest rates and declining fossil fuel prices.