Thanks again everyone for your thoughts on my original question. I think thereās a lot here that can help ANY testers wrestling with similar issues about relevance.
(Even though my original question was self-centred - sorry!)
Also interested to hear people mention cases where an apparent demand for automation skills turned out to be not quite as it seemed. Yeah, Iām sure there is an element of āfashionā to automationās appeal - just like every org now has to be Agile without really knowing what that entails.
A lot of you have rightly talked about educating and advocating within our organisations on the value of testing etc. This is definitely all good advice. I agree, of course.
Indeed Iāve done that ⦠admittedly without as much success as I would have liked ā¦with my current team by introducing them to ideas beyond their sets of test cases, like Session-Based Test Management, cognitive biases etc.
For me, unfortunately, a big issue is that I need to leave my current org and find work nearer to home (and stop the 3hrs+ a day I spend commuting) for family reasons - and for my own sanity. 
There arenāt many testing jobs near me anyway, and when something does comes up itās typically focused on automation/coding skills. I struggle to remember the last time I saw a job ad that made any reference to exploratory testing being a desirable aspect of a candidate - most of them donāt even make any reference to thinking skills.
And a testing role that doesnāt value exploratory testing isnāt appealing to me.
I know that those kind of roles do exist, in the ārightā" kind of companies, but theyāre not common. I truly wish more (all?) software hiring managers thought like Michael Bolton but they just donāt.
(See also the communityās emphasis on blogging, twitter-presence and being at the right conferences - as per James Bachās ābuild your reputationā stuff. My blog isnāt great but I do emphasise its existence on my CV etc to show hiring managers that I donāt just do testing, I also think about it. But Iāve had more than one interview where itās become clear that they havenāt looked at my blog or twitter and have no particular interest in them.)
Before testing I was in marketing and there you needed to remember, unless you happened to produce products aimed at people in marketing, the customer was not you. They didnāt live like you, didnāt think like you, didnāt like the same things as you.
Similarly Iām finding that many people hiring testing resource arenāt like me and donāt see testing in the CDT-influenced way that got me enthusiastic about it.
It does seem that ability to automate is now perceived as a requirement for a tester to some degree.
Which is fine - it happens in different kinds of industries all the time that people need to re-skill as the world evolves. But itās not something I can sell myself on with my minimal coding skills. And after years of self-learning in my own time (I started with no technical background at all) on top of a long commute Iāve come to the conclusion that I now have better things to do than taking part in the endless programming/tools skills arms-race.
And then, yeah, even if the skillset isnāt an issue, thereās potentially an age one. Chris described it well. I suppose until you reach a certain age you donāt even think about how many job ads contain (perhaps innocent) coded references like āweāre a young, fun teamā. In 1 or 2 cases where Iāve been told that I was clearly a strong candidate but didnāt get jobs because of āfitā I always wonder whether thatās a legally acceptable way of saying Iām too old. (The truth probably is that I just donāt want to admit I smell bad and am super-annoying.)
Anyway, I donāt want to seem like Iām wallowing in self-pity here. I know that if Iām not thriving in testing thatās my own responsibility and I could make different choices.
Iām sure testing as a skill has a future and its right that those involved in testing should constantly learn and adapt. The ideas and comments you guys have contributed here will help testers do that.
I just feel that I personally donāt really fit what most orgs are looking for in a testing resource. So my future probably lies elsewhere.
Not sure where exactly, but thatās a different problem. 
In the meantime I am off to enjoy the Easter weekend and as much chocolate as I can stomach!