You can read the dawn of everything book which is a very interesting take at a lot of those assumptions which are indeed false. This book goes deep into the ideological bias scientists have when interpreting evidence.

The hunter-gatherer gender division is actually proven wrong now.

Also, hunting mammoths was a very rare activity. I would expect it to be some kind of desperate activity in fact. People weren't more crazy than we are, they would rather live than to be trampled by a mammoth.

I always assumed that hunter gatherer division was mostly down to the individual, some traits make some better at hunting than others.

I struggle to locate static objects, I for the fucking life of me just can't see it. I'll be looking for something and either look right over it or walk past it multiple times

But if I go outside and look in the trees I can spot all the squirrels within seconds. Not like that's a talent or anything special, but my point is that I'd starve if I had to look for food in the brush, and likely I imagine these types of traits are what defined who did what job, meaning who was good at what, and likely considering lots of hunting was endurance based and not skill based at all, then most adults probably participated to some degree.

I've also gone shroom hunting and had to come back empty handed because I can't see the god damned things.

When you start looking at older debunked theories that lasted for a long time you can see the human bias in them. Not just a human bias but a a western bias.

Two that stick out for me:

Trees compete for sunlight - I think it makes sense to us humans because we compete for resources but in truth trees are way more 'community' based

The male alpha wolf - It's how the western world has been organized for centuries so it's easy to see that in a wolf pack even though its not true.

Hunting was mostly running a marathon while tracking until the animal collapses.
No reason to believe women didn't participate in that.

I don't think I ever heard that hunters and gatherers would have been divided by gender.

I am pretty sure that modern archeology agrees with you in at least some ways (know an archeologist, not an archeologist). I don't have any specific evidence for mammoth trapping but there are these really interesting stone funnel traps that were used to trap gazelle herds https://tywkiwdbi.blogspot.com/2011/04/ancient-gazelle-killing-zones.html

Also consider how long humans have walked the earth as hunter gatherers. Agriculture goes back to around 10.000 BCE. The entirety of time between 300.000 BCE and 10.000 BCE was likely (mostly) spent as hunter gatherers. Imagine in how many ways local roles and culture could have differed in that time!