I've torn the ACL in both of my knees, at separate times, playing soccer. So I know what you're going through.
Trust me when I say that it does get better and, like jessica. said, many people do recover. I'm back playing soccer once a week, and doing other physical things as well. My knees aren't the same as they were before (I can't kneel for extended periods of time, and can't squat down for longer than a few seconds, among other adjustments I've had to make) but they have been repaired well enough that I can still enjoy a normal, active life.
If you have any questions about the process/recovery, I'm more than willing to share my knowledge. You have a lot of work ahead of you (you'll be surprised at how much your injured leg has atrophied once you're able to take off the brace). Let me know if I can support you in any way.