Acid-resistant composite membrane as well as preparation method and application thereof