Cosmological tension of ultralight axion dark matter and its solutions