Rigidity for some geometric inequalities on weighted Riemannian manifolds