I think you nailed it when you said you found it "kind of meh". It was around when I was at school, but not overly popular that I can recall. I can't stand
Drew either.
Andy is bland (blandy
Andy). If I was forced to use
Andrew, I would give him a J middle name so I could call him AJ, or just call him by his middle name. I would be quite surprised to see it on a baby. The association with the prince has ruined it.