Couple things...
If all you are planning is just to drive from Cork to Dublin, I'd drop the car in Cork and just take the train to Dublin. If you have a complex plan with multiple stops between Cork and Dublin, check to see if those locations are served by train. That part of Ireland doesn't necessarily need a car. The southwest and west coast, yes, a car is super handy there, but between Cork and Dublin, not so much. Likewise between Galway and Dublin - if your plan is to pick up the car in Cork, drive around the southwest and west, wrapping up in Galway, then drop the car there and train or bus back to Dublin.
No downsides that I'm aware of to using the car coverage provided by your card. I did and it was smooth as silk. There's a lot of ongoing misinformation and disinformation (including some here) warning that the auto insurance provided by credit cards is not valid in Ireland (that's nonsense) or that you're going to have to mud-wrestle with the car rental agency staff to avoid having to buy their insurance (also nonsense, at least in my experience - you decline all the non-mandatory insurance offered by the agency, they should be fine with that; they may not like it - they have boat payments to make and would rather buy a round at the pub - but all you have to do is politely decline, be ready to show the letter from the card company's insurance division that clearly says you have coverage, and that's the end of the discussion, no drama, no worries). Do read and understand your policy (before you go), as you should anytime you are renting a car. Any rental agency should be OK with this (if they're not, there are plenty of others you could choose). I had zero pushback. But you will still read lots of dire warnings. 100% non-issues IME.
Of course, drive carefully, and have your left-seat passenger act as your full-time co-pilot, navigator, helper and support person. Make sure you both take that job seriously - deadly seriously (like, as serious as a head-on collision with a combined velocity of 100+ mph, which is one of the possible alternatives if you don't keep it together). Keep calm and carry on, and have fun. Ireland is wonderful.