I always wanted a daughter, but was blessed with two sons, which I have never regretted a single day in my life. I'd not heard the song you posted, but this one is the complement when one has a son.
My most memorable moment was when I held my first son in my arms seconds after he was born and he opened his eyes... looking directly into mine, and held them there, with mine gazing tenderly back. Nearly 30 years ago, my memory is as clear as if it happened only a moment ago.