As a former manual tester, and trying to be honest, the following looks increasingly likely: If you stay as a manual tester - you are pretty much screwed.

But not because of Automation - that's an overlapping but incongruent skillset, which doesn't exactly replace Manual Test, rather compliments...