It works best as a complement to a complete service like 1Password or LastPass, but it just isn't convenient and robust enough to act as a standalone password manager. Ultimately, iCloud Keychain can be put to good use if you've carefully examined what it does well and doesn't do well. Important functionality is hard enough to find that it may be effectively hidden from the average user, particularly on iPhones and iPads. iCloud Keychain does accomplish the most basic things you'd expect a password manager to do, but it often does so in an awkward manner.
In the latest versions of OS X and iOS, Apple's new iCloud Keychain provides one of the most important pieces of functionality for security-conscious users: a password manager.