Best of luck with your surgery - I hope that all is going well.
I'm just over a year out from a hamstring graft ACLr, and for me at least it was an excellent decision. I have no restrictions now; in fact if anything my knee is stronger than it was to begin with after all the rehab. I was able to go back to skiing seven months after surgery, and this summer I've been hiking up mountains and riding in bike marathons. I hope this goes some way to reassure you that there most definitely is life after ACL surgery.
The immediate aftermath of surgery isn't too much fun. The most important things are to stay on track with your painkillers (set an alarm during the night so that you take them at the right intervals), ice lots and lots and lots and keep your leg elevated (with a cushion under the foot, not the knee), and don't try and do too much. Your body has been through a big trauma and needs time to recover. Once you're through the first few days, things should improve a lot. Prepare yourself for a lot of weird sensations, like the nasty blood rushes to the calf that you get after lying down for a long time and all kinds of odd feelings in the shin from the nerve that gets cut during surgery. The hamstring harvest site will be sore, so make sure you move very gently for the first few days.
Make sure you have a really good physiotherapist, and stick to the rehab protocol to the letter. Recovery is quite tedious because it takes so long for the graft to heal and strengthen, but as long as you do your exercises and stick to whatever restrictions you're given for the various stages of rehab things should be fine. Keep focused on that goal of being able to enjoy a kickabout with your little boy - that will do a lot to help you through the down times (and there will be some - it's a long old haul and inevitably frustration gets the better of you every now and again.)
Good luck! Do let us know how you get on, and if you have any questions let us know - there are lots of folk on here who have been through ACL reconstructions, and I know that for me it was hugely reassuring just to find out that what I was experiencing in the aftermath of surgery was completely normal.