The contents being generated are nothing special. They are just various kinks and fantasy and some hardcore stuff that have been floating around since forever. It is just more accessible and easier to make them now. And considering where they come from, this is probably an improvement since no real human is involved or harmed for it.
The only thing I can see people worry about is someone putting a real person's face on a porn image. But deepfakes are also around for years and we don't really care or affected that much. Why bother with what people do behind closed doors? As long as they don't harm anyone, what they do in private is their own business.