As a general rule, all car rental agencies in Ireland seem to be closed on Sundays (many on Saturday, too). That's especially true in smaller towns. The exception is rental agencies at airports - they all seem to be open on Sundays, often 24 hours, too. Find an airport somewhere nearby. Kerry Airport (in the town of Farranfore) has a car agency that's open sundays (I know because that's where I was going to drop my car on a sunday morning, until I switched to the airport in Cork instead, since that works better for us to catch a train to Dublin).
You will need to re-arrange/tweak your plans accordingly (as I did when facing the same day-of-the-week limitations).
Insisting on a car with automatic transmission will just turn the difficulty knob up to 11. Consider investing some time to get conformable driving a stick at home before you switch sides of the road. The shifting-gears-with-your-left-hand thing just takes a few minutes to adjust to (just be glad it's not your car as you grind those gears...). By contrast, driving on the opposite side of the road requires constant awareness - be very careful with that. Hopefully you are not driving solo; assuming you have a passenger, it's their job to sit next to you, help navigate, and regularly remind you to stay on the left side of the road (especially challenging immediately after you make a turn onto a new road, it's easy to forget and start driving on the wring side). You co-pilot should offer helpful advice regularly. Be careful.