Yes, the child's health is paramount.

The LW thinks that her sister is picking her pets over her niece, but the LW is actually picking her convenience over her sister's happiness. She should get over it and book a hotel. It's unreasonable to demand someone get rid of their loved pets for the sake of a once-a-month visit.