No, God doesn't want any of us to sit around and simply wait for death, no matter how good or bad our health is. After all, none of us knows exactly when we'll die; you might even have many years ahead of you!
The key is to discover what God wants you to do right now—and then do it. God knows your limitations, and He knows you can't do everything you once did. But ask Him to show you what you can do, and make yourself available to do it. Your pastor, for example, may know of some things you could do around the church to help others, if you have the strength.
Remember, too, that even if your strength is small, you can still pray. I've often said that our own ministry has only been possible because of prayer, and I have no doubt that when I get to heaven I'll be amazed at the number of elderly and disabled people God used to pray for us. Paul wrote, "Finally, brothers, pray for us that the message of the Lord may spread rapidly and be honored" (2 Thessalonians 3:1).
In addition, ask God to help you be a witness for Christ to those around you—not just by what you say, but by the way you live. Do others see Christ's love in you, and do they see the hope and peace we have in Him? Remember: What we are is just as important as what we do.