There was drama at Kingspan Breffni as Cork withstood a late Cavan comeback to take a deserving victory and secure their place in the Sam Maguire for 2025.