A drunken father of three who crashed his car into two French tourists who had arrived in Ireland hours before causing them catastrophic injuries which killed them instantly has been given an eight-year sentence.