There's nothing as sexy as a man who changes diapers.
No man EVER got shot doing the dishes.
The words "Honey, go back to sleep. I've got this one." are the biggest turn-on a new mom can hear.
A close second would be either "I don't know how you do it. Here, let me rub your shoulders a little." or "You're still as beautiful as the day we married. I love waking up with you every day."
Some guys (I hear) are naturally sensitive. Many need a "how-to" guide. Same with women.
Remind him that you can get anything when you pay attention to timing & delivery. In this case, his timing might affect your delivery! How & when he asks definitely impacts your response.
I know it's hard in your new mom, sleep deprived state, but re-set things -- for both of you. Try to bring some fun into this discussion -- again, for both of you. Make index cards with statements like the above. Put the statement on one side and then what you're willing to do for him if he does that for you. For instance, a 1-minute neck massage gets him one deep, long kiss once the baby's down. Have fun! Really -- at this point, you both need each other more than you realize -- and in lots of ways.
Relax. It will be OK.
Hug to you as you learn how to balance your new role with your old role and WITHOUT losing yourself in the process.
Really, it WILL be OK.