Known for her melancholy, existential lyrics, Hardy rose to prominence in the Sixties and became one of France’s most celebrated artists