add_resource() has a delim parameter, but it only serves to indicate the delimiter of an existing file. It does not influence how dataframes are written (always csv). This should be explained in the documentation at https://docs.ropensci.org/frictionless/reference/add_resource.html