First of all, I want to tell you that you are playing a very important role in your team. The skills that you have mentioned (exploratory testing, scenario testing, proper analysis and knowledge of SQL) are actually vital for a successful project. 
I know certain instances where some scenarios were missed during testing because of a lack of proper analysis. 

In your case, I must say that it is just a matter of going for it (automation).
You will be successful in that too.

Now coming to the question related to demand of manual vs automation testers.
I am of the opinion that the demand for manual testers will gradually decrease.
As of now, the industry has already put a lot of emphasis on automating regression testing which was being taken care of by manual testers earlier. And efforts are being made to automation more manual work that the manual testers are doing.

So, yes, smart manual testers will always be there and retain jobs. Because I don't see 100% automated testing as a good idea and even it's not feasible as well.

But, overall automation will increase with an increase in demand for automation testers. And it will adversely impact the demand for manual testers.

For you, I would suggest to start learning automation. Because if you work on SQL and understand the logic, and also you are good at identifying business scenarios, I believe that you will easily pick automation and programming concepts required for it.

After all, there is nothing wrong with having one more arrow (automation) in your quiver. :-)