Chandra grating spectroscopy of embedded wind shock X-ray emission from O stars shows low plasma temperatures and significant wind absorption