I think this is one thing that is conveniently ignored and dismissed by the people advocating for every person being asked or expected to tell everybody their pronouns all the time.
For the vast majority of us English speakers who only ever use pronouns as has been standard for a very long time - he for a male, she for a female, they for an unknown or generic person e.g. 'the customer' - being asked for your pronouns is akin to being asked what sex you are, which is taken as a pointed attempt to insult.
Most women would be grossly offended by somebody facing and looking at them (it's different if it's just an ambiguous name on an email) asking if they're a man; and the majority of men wouldn't want it to be thought that they're a woman. Not that there's anything remotely wrong with being a man or a woman, but the two look distinctly different. There's nothing at all wrong with being a child, but most people over 25 wouldn't want to be asked if they are one.
As far as deliberately giving offence goes, it's not that dissimilar from seeing a woman lovingly breastfeeding a baby and asking her if she's that baby's mother; or being told proudly by a committed long-time married male friend or associate that his wife is pregnant, and asking him if they know who the father is.
So much of this is inevitably going to upset and concern many, many people (it looks suspiciously like it's by design) - but as they aren't the ones being centred and considered remotely important in this, and as long as the tiny minority get their beliefs and fantasies made the entire focus of everybody's attention, apparently that's the sole thing that matters.
Surely nobody genuinely believes that asking an obvious woman or man to state their obvious pronouns is anything other than a vehicle for a handful of people to centre the attention on themselves and say "Well, unlike you, I am different and special!"? Like that boring person who once briefly met the king at a charity event or garden party, and then every single conversation they ever start begins "Have YOU ever met the king?!"