The singer has since dedicated herself to raising awareness of SMA after her twin daughters were born with the condition