Rigidity Results for Compact Submanifolds with Pinched Ricci Curvature in Euclidean and Spherical Space Forms