Theory of nonequilibrium noise in general multiterminal superconducting hybrid devices: Application to multiple Cooper pair resonances