Asymptotic Stability of the Wave Equation on Compact Manifolds and Locally Distributed Damping: A Sharp Result