From Fragile to Resilient Automation: The Organizational and Data Challenges of End-to-End AI and Optimization in Supply Chains