They share notes but serve different harmonic functions.
Notes: C – E – G – D (adds the 9th/D above the octave).
Sound: Open, bright, expansive. Common in pop, folk, jazz. Resolves like a major chord with extra shimmer.
Notes: C – D – G (replaces the 3rd/E with the 2nd/D).
Sound: Suspended, ambiguous, neither major nor minor. Yearns to resolve to C major (D→E) or C minor (D→E♭).
On piano: Cadd9 = C-E-G-D (spread voicing). Csus2 = C-D-G (omit E). Not interchangeable.