Someone who sets their sights high but lacks the ability or willpower to do it. (name based on the idea that aims for the moon but suffocates in space, references James Bond too)
Will:dude, did you hear peter quit smoking?
Me: what a moonraker he'll never keep that up
Will:lul