Ceramic diaphragm as well as preparation method and application thereof