Optimal Sparsity-Sensitive Bounds for Distributed Mean Estimation