my question is about whether an experienced manual tester who has istqb foundation test certification but with no automation experience can take the Advanced Technical Certification exam?
Yes, you can. Provided you have your ISTQB Foundation, you can take the Advanced Technical Test Analyst course and exam.
Edit: I've previously worked with a functional test manager who took the technical test analyst course and, unfortunately, failed. I think he found it harder without any automation experience as one of the modules is Test Tools and Automation... that doesn't make it impossible though.