Applicator for cosmetic product, in particular mascara, associated applicator assembly and method of manufacturing such an applicator