Superconductivity and bosonic fluid emerging from moiré flat bands