A retaining wall primarily prevents soil erosion and provides structural support, while a sitting wall serves dual purposes: extra seating space and decorative hardscaping.