After his defeat, Ganondorf is turned to stone with the Master Sword still embedded in his forehead, as the ocean crashes down on top of him. Given that characters who are Taken for Granite in the Zelda series are often still aware of everything, it's likely that he's still conscious and trapped forever at the bottom of the ocean