A song without a drumbeat is a story without words - possible but unlikely. Let your friend enjoy his aspiration. Is he willing to do gigs? Even the birthday bashes? Is that that the price of his passion? Would he be alright with doing just birthday bashes, forever?
Let him dwell on that thought. If it is, being a drummer might be great.