A man in his 80s has died after he drove the wrong way down a motorway before colliding head on with another car on the outskirts of Cork.