Linking the collisional history of the main asteroid belt to its dynamical excitation and depletion