My dad had a 96 z71 that did the same thing. Fluid was good, no slipping, never whined in neutral or park, only in drive during acceleration. Turned out to be the converter.
This truck started slightly whining around 100k, got really loud around 140k.