Short term, cyber security is governance with a high technical competency bar to entry at any serious level, and the reason we're still in demand and these problems aren't solved is because competence at managing dynamics and risk is still irreducible. Every model and formalization creates a dynamic with whatever it models and formalizes, which creates an opportunity to exploit and manage it. AI mainly creates manageable dynamics and demand for governance, which means no matter what you're going to need hackers unless we're all livestock.
Long term, security as we understand it today will go the way of the Orange book, and it will evolve as a variation what it really is, a purer understanding and way of relating to tech. Fundamentally, hacking is the logic of an idea that we can apply to anything, where instead of goodguy/badguy, or oppressor/oppressed, we have true/false, where something is only true within the domain of its assumptions, and when you change those, you get understanding and leverage. It's all the things that work in practice just not in theory. AI is a figment of aggregated and nested assumptions, so all I see is opportunity. It will be as pernicious as human conceit, and I'm pretty sure it's going to kill a lot of people, but I'd say if you don't have the practice, you don't know what you don't know about our advantages over it. We're good. :)