Flexible repairable super-hydrophobic membrane as well as preparation method and application thereof