Many state-of-the-art compression algorithms are in fact based on generative models. But the thing is, the model weights themselves are not the compressed representation.
The trained model is the compression algorithm (or more technically, a component of it... as it needs to be combined with some kind of entropy coding).
You could use Stable Diffusion to compress and store the training data if you wanted, but nobody is doing that.