My take Superman would probably see it as a relief, him and Kara Zor-El (and the people in the bottle city? and whatever else the writers came up with) are like the only surviving Kryptonians, so having their kid not be a living reminder of their destroyed home planet would be nice, and if the kid also took up the cause of saving humanity he’d be proud no matter what powers the kid had