There’s also the obvious privacy problem of family members stalking each other.
That being said, if you aren't comfortable with family members knowing your location, then why would you want to share AirTags or an iCloud with them in the first place?
I’m not saying it’s impossible, just that it’s a difficult and tricky use case.