As soon as digital products such as websites, web apps, games, software are increasing at multiplying rate, the need for manual testers would also multiply. Though we are seeing the rise of automation tools & engineers, the role of manual testers will not be easily replaced, as they are also needed to look & test the product in terms of user experience, which automation tools can’t humanely do.
The purpose of both manual & automation testing is to fill each other’s shoes. Automation testers aim is to speed up the process of finding & fixing the bugs, with 100% test coverage, without clerical mistakes, while the role of manual testers is to check the gaps these tools missed and to test the overall human experience & usability for those digital products & software (which are ultimately to be consumed by humans not machines).
While if you are still afraid about “is manual testing a good career”, plan an upskill for the future in Automation Testing as well & become a complete resource who does both sides of manual & automation testing.