If the target creature is an illegal target at the time Manhole Missile tries to resolve, it won't resolve and none of its effects will happen. You won't get to put a card from your hand on the bottom of your library, and you won't draw a card.