Is it normal to love a sober man but hate him when he's drunk?

My boyfriend is a drunk. He doesnt have a job & even tho he says he is activly seeking employment, noone ever seems to call him for an interview. He eats up ALL of my grocery's(which he doesnt help buy) and uses my deoderant. He drinks during the week and he doesnt have a car. I allowed him to move in with me a month ago & I feel like I'm losing it! When he drinks he gets REALLY stupid. Like tonight, I asked him to take some broken glass out to the trash. The glass was from a picture frame that I specifically requested be brought back into the house. But because he had been drinking & wasnt paying attention to what I was saying, Yes, he thru it in the trash. I have bills due but no money & he tells me that he spent all of his money today. ???..What money I ask, but get no reply. I kno tht there r a lot of things listed in this story that I DO NOT like about him, but on the other hand, when he is sober, he is the most loving, caring, generous(when he has it), funny,affectionate,sweet,encouraging, person in my life. He helps alot around the house, he would drop any & everything if I need him, he loves my daughter as much as he loves me,he puts up with MY craziness & he would do almost anything for me...except stop drinking. I love him for those things that he is. But at the same time I hate him for being a drunk. I believe that he drinks because he feels like less of a man because he cannot provide for us the way that he wants too. That's something he talks about often. I try to make him feel better by reassuring him tht I love him for who he is & not what he can do for me, but now I feel sum kinda way about it. The sex is AMAZING. But Im not sure all of tht is enuff. Im torn between loving him, having faith that things will get better & kicking his drunk,broke ass to the curb. Im so frustrated with this relationship right now I dont kno what to do with myself. Any advice?