In the short term, attorneys at any major commercial enterprise are going to look at Stable Diffusion's license and shudder.

The license is well-intentioned, but the use-restrictions are both broad and vague-enough that they may add extra unnecessary liabilities that one doesn't generally expect to find from a graphics-artist contractor.