Tartness is just on the tip of the tongue, sourness is everywhere in the mouth.

Tart = good palate cleanser, gets you ready for the next thing

Sour = everything you eat after tastes sour, too