Do all family members need to use the same system or live in the same household?

No. A Nintendo Switch Online Family Membership is linked to the Nintendo Account – not a specific Nintendo Switch console. It can be used on any Nintendo Switch console that the member signs in from.