Charlotte is the feminine of Charles. It is also Pipa’s middle name, Kate’s sister. The choice makes perfect sense. I think they chose very thoughtfully and wisely.
There is another close family connection to the name. Earl Spencer’s (Diana’s brother) 2 yr old daughter is named Charlotte Diana.