The phrase "major turnoff" means something that strongly repels or disappoints a person, causing them to lose interest or attraction.