Flame-retardant composite diaphragm as well as preparation method and application thereof