Retail investors feel less polarized about ESG than those in financial services may believe, research finds.