Emergent coexistence and the limits of reductionism in ecological communities