A popular French author and presenter has sparked widespread criticism around the world for saying that women over 50 are "too old" to love and "invisible" to him.