Because it's always been a steadily popular name, neither name of the moment or obscure, I don't think people hear 'Andrew' and think 'Mountbatten Windsor'. I can think of about 10 non-famous Andrews I know of various ages, and I'd describe myself as quite reclusive.
If I associate it with anything, it's Scotland, for obvious reasons.
But, good luck to the Council of Andrews, sounds like it's helping the members.