The rival to Twitter saw explosive growth but users have since drifted away, Meta boss acknowledges.