Not sure about Stable Diffusion / Metawhatsit, but OpenAI's training set is already curated to make sure it avoids violence and pornography; and in any case, the whole thing relies on humans to come up with descriptions. Not clear how this sort of thing would "spike the well" in that sense.