AI promised to make security smarter and faster, but companies are now asking if all that automation truly pays off.