A vote of no-confidence aiming to bring down the nascent government of French Prime Minister Michel Barnier has failed after the far-right National Rally party refused to back the motion.