you said that the roaring noise that is heard when driving that is a positive speed coeficient is not heard when the car is in the air. the reason is because there is no weight on the bearings... that is... if it is the bearing making noise. Im not so sure about the fluid pump.... i was just thinking... maybe a CV goin out??? i highly doubt it though...

Much props to boost for beating me to what i was thinkin of sayin.. touche.

Little bit of rise out of front mount maybe 1/4"

I would suspect only TC and pump is moving at idle, but don't get noise in park
As I start to roll forward just off idle is the only time the rotational noise is heard
With vehicle in air, noise is still heard in trans /oilpan area

Kind of a crunchy squeek for a while stopped and only a few revolutions
very noticeable inside and outside the car

Try jacking up the front of the car. With the engine off and in neutral turn the tires. Listen close for any noise. If you do here any it rules out the pump. Leaving the hubs, axles and TC.

People have cracked flywheels. Did you get a chance to look in there?

Not yet, on the F/P or the off test
With the car in air and wheels blocked, noise can still be heard, so that eliminates brake/hub/axle

Still No codes,
Drove around town for 1/2 hr with no hard shift and no noise, stopped for 15 mins or so and drove away to hard shift and noise returned

Was there ever a tie to a electrical glitch with either ECM/PCM with the shift solenoid?
or do the only fail from gum/varnish sticking issues?