To a first approximation:
Tablature is a _physical description_ of how a particular stringed instrument should be played, and the notes are a side effect of that. It is instrument specific and it doesn't contain much information about the musical details of the piece.
For example, tablature doesn't describe the key the piece is to be played in. To figure that out, you have to mentally translate the mechanical description into notes, and from there determine the key.
Standard notation is a _musical description_ of how a particular song should be played, and the physical act of playing is a side effect of that. It is not instrument specific, and it contains a lot of information about the musical details of the piece, but usually no information at all about how a the instrument should be played. (There are a few minor exceptions.)
For example, standard notation tells you exactly the key the piece is in, but the player has to mentally translate the notes into the physical steps of getting that note out of the piece.
Basically standard notation adds a layer of indirection from the music to the mechanical act of playing. Like many indirections, it can be hard to understand at first, but has adds great power and flexibility that a direct system doesn't have.