A report has found that the family of Captain Tom Moore damaged public trust in charities by refusing to donate funds obtained by "misleading" the public.