Personally I think it is all hogwash and suspect that it is not much different from numerology or other such superstitions.
Then again, there is much to be said for a name. Would Oprah have been the success she is today were her name Mary-Sue? Would Madonna have been equally iconic if she was known by her middle Louise instead? Or if she hused her family name and was known as Madonna Ciccone?
I once had a friend who were verbally and physically abused by her father. As an adult she decided that the negative associations with her name--her father always shouting her name--disturbed her, so she took up another name. She wanted a unisex name so we decided on Toni. With her new name, signifying a new start and a strong character, Toni was able to commence her journey of recovery after years of abuse.
Similarly, my younger brother who has a four syllable first name that people always mispronounce decided to shorten his name to a two syllable name. Later still, his friends adopted a one syllable nickname, Nate, which most people now use. While I liked the two syllable name, Nethan, I also like the name Nate. These days I see that he use different versions of his name, the original four syllable one, the two syllable one, and the one syllable one, in different situations, to good effect.
I'm sure that my own name also had an influence on who I am today. My real names are proper English names. However, our nanny gave me a Sesotho / Tswana name, which ended up becoming the name my family used. I grew up with an African name, which always made me stand out within white contexts. I'm sure this must have had an influence on how people treated me, and how I interacted with people. (If you want to know my name, you can see it on my poetry blog: Ingelegde Lywe.) In Korea my name is very similar to a common Korean name 상국, so that Koreans always ask me after I introduced myself to them if it is my Korean name, then I always have to explain to them, no, it is an African name, I am from South Africa. It has become such a trite routine, that I am shocked when it doesn't happen. Since my name sounds Korean I have opted to use 이상구 Lee Sang-Goo as my Korean name.
While I still think that the Korean Sound Name Wave Institute is a sham, I agree, that there is much to be said for a name.