Core-Collapse Supernova Physics in the Multi-Messenger Era