Pros:
Dramatically better LOD as there no MIP maps. Consistant appearance at all distances
Can be used strategically in the same NIF (one node use TGA, another use DDS)
No compression artifacts
No specular issues from normal maps
Cons:
TGA files are natively larger and must remain unconpressed
Requires models have vertex colors applied
TGA files will not display in CS (and produces ignorable wanings)
No normal mapping possible
No transparency or parallax with 24-bit TGA
Can't be used on rigged meshes