The trouble with rockets is that you have to pack everything before you go. While earthly modes of transport all work within their environment, shooting around air or water or rolling along a surface, rockets must carry whatever they are going to shoot out the back - reactive mass - with them. This effect is exacerbated because the reactive mass you’ll be using at the end of the flight is just dead weight at the start. So you need even more mass and energy at the start just to lift the mass and energy you will need later on. This is why it is so challenging and expensive to get into space. Rockets are so big compared to the payloads they launch because they need to be more than 90 per cent full of propellants at take off.
Once you’re in space you have more options: craft don’t need to be aerodynamic and the engines don’t need to support a craft against gravity, so a small thrust over a long time is equivalent to a large one over a short time. However, if we want the space travel of fiction, to voyage across the stars to find other planets and life, the challenge gets even greater.