Conflicts of interest and "serious mismanagement" a footballers' charity put funds to help players in need at risk, a Charity Commission inquiry says.