Tbf, Stable Diffusion can actually run on some pretty low-spec hardware these days. That said, it wouldn't surprise me if it was indeed run on cloud hardware, especially given the creator's resume.

Edit: Also, to refer to the previous comment, not happening on a Pi Zero. Just to head off that comment, lol.