Our house uses dry blown cellulose, but should be much the same in terms of acoustic performance to the wet sprayed stuff, I should think. It is exceptionally good as acoustic insulation, especially when you consider that we have no masonry construction at all. The house is eerily quiet, especially at night, and any slight external noise that does get in seems to be via the windows and doors.
I would imagine that if used to fill internal walls cellulose would out-perform rockwool as acoustic insulation by a fair bit. I think the only problem may be finding someone with the kit to install it, although it doesn't look to be a particularly hard job to do.