Keeping global temperatures within safe limits is incompatible with new fossil fuel extraction, as stated by the International Energy Agency. This should be reason enough to oppose any new North Sea extraction of fossil fuels.
The UK oil and gas industry is already in terminal decline, producing just a fifth of the oil and gas it did at the turn of the millennium. New drilling would not arrest this trend.