Sports psychologists have to cope with "fear and uncertainty", job insecurity and long working hours when working with elite footballers, research shows.