Currently I have a detached pipeline which uses the Terraform with the remote Gitlab backend.
How can I after the pipeline has run delete BOTH the assets created and the statefile?
Currently Terraform can NOT delete statefiles stored in remote backends. The feature request for this is 34172.
Now what you have to do is run
gitlab terraform destroy
to have terraform remove all assets in the state file,