Magnetic moments of nuclei and the nuclear many-body problem