Transient instability for complex ecosystems