Close to half of all primary school principals could leave the job in the short or medium term, a survey has found.