But at least “big bear” is consistent. That’s literally what Ursa Major means, and that the name it had basically for 2000 years now.

The reason it doesn’t remotely look like a bear is because this is just the ass and tail. The whole thing looks like this:

https://upload.wikimedia.org/wikipedia/commons/thumb/1/13/Ursa_Major_IAU.svg/1280px-Ursa_Major_IAU.svg.png