I fear that will require changes beyond pure AI for now. I was able to reign it in with my personal tweak mod by limiting their placement and it works great but its not an AI change.
I've been testing out some AI tweaks in isolation and found they do a decent job of settling with the stock AI by tweaking the value of plot yields alone. The problem is that every change has a cascading effect on other changes so fixing one thing breaks another, like your issue with archery vs. astrology. I'm also finding that quite a few values appear to work the opposite of what I expected or seemingly not at all (likely small differences that are hard to see). But I'm going to keep trying to force this square peg into the round hole until they give us the DLL source
I've tried radical changes to the tactics in AIFavoredItems with no visible effect in game unless combined with other changes but even small changes with some PseudoYields make a significant impact.
I have a bunch of changes I'll be happy to share with you so you can test them too, I do everything in SQL though since I find it much easier to manage on the mod level than a bunch of XML files.