New52 Superman will likely be alive with no powers (or possibly less). My guess is that he'll end up going by another superhero name when all is said an done. He'd make a great supporting cast member. A lone strong man folk hero, traveling the country, saving people in need.