1996 Cadillac DeVille -Trans?

Is it the pump that goes bad in the transmission

Not always, can be many things.