Those headlights aren't to bad for the age of the vehicle......They would be way worse if it sat out it the Texas sun even half it's life.
It's near impossible to obtain a brand new 4L65E, Probably has a GM Remanufactured (SRTA) unit installed. You could buy a brand new 4L75E through GMPP, But it would have the wrong Torque Converter & be a 2wd model which would require disassembly to swap to a 4WD/AWD output shaft.
I'm assuming it's AWD as I've never seen a 2004 2WD Escalade/Escalade ESV with a LQ9......They had the LM7 5.3L.