What is the French's favorite drink?

Very probable - cognac.

Also: calvados, armagnac, champagne, pastis, absynthe, wine, beers

The French, collectively, probably drink more water than anything else.

Wine and Champagne