Whether petrol or diesel t’ll all get burnt by somebody somewhere. Europe has a surplus of petrol from refineries that gets shipped elsewhere (burning fuel oil) unless we burn it so the CO2 difference argument is moot. I’d rather not poison my local community more than necessary with super fine particles and NOX so drive petrol.
Consider the difference in servicing costs, price of vehicle and real world economy in your equation. Diesel engines used to last longer before major bills but I’m not so sure that is still the case. petrol engines have improved whilst diesels are more highly stressed and with more expensive, complicated parts to go wrong than ever.