Radiation pressure, absorption and AGN feedback in the Chandra Deep Fields