I think Sofia is beautiful.
To put a positive spin on it, try to remember that the #1 names don't have as many people as the #1 names did back in the 80s. For example,
Sophia was number 1 in 2011 with 21,695 little girls being given that name. In 1982, Jennifer was number 1 with 57,099 little girls. That's nearly triple the amount of girls with that name. So while there will likely be other little Sophia's in her school and class, it won't be to the magnitude that Jennifer was.
Don't regret it, use your name. :)