I think it heavily depends on the individual. Personally I've gone from nearly sedentary to running ~35 miles per week (and lost ~15 lbs in the process).
Experiences are so varied across the board. It wouldn't surprise me if overall people, like me, were worse off in general health terms.