I've never found these alleged cliffs either, unless whoever wrote the song was referring to the cliffs just outside Kilkee as you drive south out of the town. You drive up the hill, park by some rock pools (a couple of which are big enough for kids to swim in) and then walk uphill for a quarter of a mile or so.

The cliffs are indeed high and rocky and very jagged as well. Instead of a sheer drop in places they go down to the sea in layers and if you're careful you can climb down as far as the surf. Watch out for the holes in the shelves of rock as it's a sheer drop from them into the sea a couple of hundred feet below. Stunning place.

I've been there twice and both times the weather was glorious.

Don't take kids, though. It's far too dangerous.