Exxon Mobil was demoted from the top credit rating by Standard & Poor’s for the first time since the Great Depression as the collapse of the biggest oil-market rally in history strangled cash flows.