Céline Dion admits she didn't feel "confident" when she was growing up following the star being named the new global ambassador for L'Oréal Paris