The health of children in Wales is shocking and outcomes for young people are worsening, doctors say.