It's possible to use the iCloud password instead of your local account password, but it's very opt-in and not at all suggested by default. Signing into iCloud doesn't replace anything about your local accounts besides that.