Spectral Estimators for Multi-Index Models: Precise Asymptotics and Optimal Weak Recovery