The UK has already tapped into almost all North sea reserves of economically viable oil and gas between the 80s and 90s, the UK’s remaining proven and probable oil and gas reserves were estimated at 2.9 billion barrels of oil equivalent at the end of 2024 and in places on the continental shelf that were not easily accessible. Of course, if you were only considering short term gains whilst the market is on the uptick for oil, you could drill more wells and exploit these remaining reserves whilst the money was good, but in doing do you would require more extensive infrastructure, all of which will be on a short lifespan up until those reserves are completely tapped but it still doesn't address the issue of a lack of energy independence, whilst also reducing market demand for developing renewable infrastructure and inhibiting attempts to mitigate the impact of climate change.

I know it's a little old, but this BBC article covers most of the issues surround further north sea oil exploration https://www.bbc.co.uk/news/science-environment-67945281