So when material science reaches the limits of all there is to possibly discover, and our conscious awareness is still a mystery, what then?
I'm not sure how we could ever know when science has reached the limits of all there is to possibly discover, but if that were so, and if conscious awareness would still be a mystery, then we would have to look elsewhere for other possible answers, validated of course by as much reason and evidence as we could muster. And if we couldn't find another alternative route, then we would have to say 'we don't know' as a holding position.
Now let me put the same argument to you:
If science is able to give a complete answer which solves the problem of conscious awareness, and this answer excludes your idea of a soul, what then?