On the iCloud family settings page you can enable/disable sharing your location with the rest of your family. I imagine AirTags would be the same.
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?