Mechanistic Insights into Light-Activated Catalysis for Water Oxidation