With a sweeping sculptural roof, three auditoriums and public spaces overlooking the Huangpu River, the new cultural landmark by Snøhetta opens, making a compelling case for architecture that brings people together