In the United States, it depends entirely on how the person is thinking about the animal. "He" and "she" are considered respectful, "it" is considered cold.
"He" and "she" are usually used when the sex is known. A rooster (male chicken) is "he." A hen (female chicken) is "she."
"It" is used when the sex is not known, particularly if the animal is considered to be a pest, or verminous. Thus, for most of us, a spider is usually "it" even if we suspect it is female. "A spider! Ugh! Kill it!"
However, a naturalist who admires spiders, or the novelist E. B. White in "Charlotte's Web," will say "she." "Watch her as she spins her orb web. It is amazing how she is able to get the spokes equally spaced."
When we see a pet together with its owner, we do not want to use "it." We can ask, and the usual phrase is "Is it a 'he' or a 'she?'" Or, we may guess, and let the owner correct us:
"What a cute puppy! He's adorable!"
"It's a 'she.'"