The majority of parents say fines for unauthorised absences would not deter them from taking their children out of school for a holiday, a survey has found.