Yes, each family member needs to download the app.
Before the cruise, to access the app a family member would need to set up a Disney account and then enter your reservation number.
Once at the cruise terminal or onboard the ship, the Navigator app changes and anyone onboard can access it, as dreamer17555 described.