Is the collective noun of a family five members is family?

Yes, the collective noun for a family of five members is family.

While you could technically use other collective nouns like "group" or "bunch", "family" is the most specific and natural choice when referring to a group of people related by blood or marriage.