NHS trusts are improving but there are still major areas for concern, such as combating superbugs, a report has found.