The Hohmann transfer orbit is significant in space missions because it provides a fuel-efficient method for transferring between two orbits. It utilises an elliptical orbit to move a spacecraft from one circular orbit to another, minimising the required energy and propellant consumption.