I was in your position, realizing I had to do something about how my family manages passwords. I found the built in Passwords app in MacOS was actually sufficient for our needs.
EDIT: youtube reviews are really negative about Apple Passwords, but, those reviews all link to other (paid) password managers, so they cannot fully be trusted, since they're essentially in competition.