Thanks, everyone. I appreciate all your comments and sharing what works for your family.
He is definitely aware that he won't have time for video games and such, so I'm not worried about that, but it sounds like it is possible to not have him be overwhelmed with baby duties when he gets home and still have him take over enough for me to get a little bit of a break. I know it is all about finding that balance, and I know it won't happen until the baby is actually here, but I like to be prepared with thoughts and ideas at least. =) He mentioned wanting to be more diligent about taking a shower right away (instead of waiting) when he gets home from work so that he isn't all sweaty when holding the baby, so that might be the perfect start to letting him relax after work with a nice hot shower, some down time on the couch, and then he gets the baby and I get to shower after that. We'll see if it works in real life though!
That being said, any other advice or stories are always welcome!