Well, names can date you. And different names date differently. For example, there were loads of girls named Sarah and Emma when I was at school. Although 'overused', these are classic names that are likely to kick around in the background for a while before coming back. Even now Sarah is still within the top 150 names, while other names that were popular in the 1980s (eg Joanne, Gemma, Jason) are a lot further down the list.
Names like Shirley, Linda, Brenda, Gary and Eric are also tied to a very specific era. It's just something to be aware of.
However, I think there's more information out there about baby name lists now. The UK didn't even used to collect data on the top ten names. We also have the internet to give us more info. Parents just used to pick names that sounded nice to them - they would have no real way of knowing whether a name was in the top 10 or top 100. Now parents are a bit more cautious about having a too-popular name.
Also, I think I read somewhere that there's more variety in names now. So whereas 12,000 girls might have been called Sarah in 1980, making it the number 1 name (figure entirely made up), only 6,000 girls might have the number 1 name in 2020.
If you look back to the Tudor period, variety was terrible: three of Henry VIII's wives were called Catherine, two were Anne and one was Jane. Other Tudor names for females were Elizabeth, Margaret and Mary, and that was about it.
Tudor men were almost all Thomas, William, Henry and John.
Personally, I'd be hesitant about choosing a name that came from nowhere and is likely to fall just as quickly. I'd be okay with a name that is very popular but has enough heritage behind it to make it fashionable without being faddy - I would put Sophia and Sophie in this bracket.