Aiming for orbit and running out of fuel means you will probably fall back and burn up in the atmosphere.
Aiming for the moon and running out of fuel means you can still get to orbit (which is still very cool) but you have to plan ahead.
Mishandling rocket fuel and blowing up is always possibility.