Plans to run passenger services on a former freight line will not go ahead, the government confirms.