ON DELETE SET NULL only works if you set it on one of them. Otherwise you get this error:

"Introducing FOREIGN KEY constraint 'FK_Consequence_RiskMatrixAxis_LikelihoodAfterSafeguard' on table 'Consequence' may cause cycles or multiple cascade paths."

I'll try the INSTEAD OF DELETE option and get back to you.