So where did the water all go?
Into the mantle.
The ability of minerals in the mantle to hold quantities of either water or hydrogen and oxygen has increased as it cooled. The water (or components thereof) that are in the mantle now couldn’t have been there when it was hotter.