The singer applied for conservatorship over her son in 2023 citing severe mental health and substance abuse issues, but was denied