A hard-fought 2-25 to 1-22 victory over Waterford secured Cork's provincial final berth against Limerick and qualified Pat Ryan's side for the 2025 All-Ireland series.