After the charity watchdog found the family of Captain Tom repeatedly benefitted personally from a foundation set up in his name, neighbours tell Alex Ross it’s time for his home village to move on