The RESTORE command is not supported on streaming tables, which is why you encountered the error. Instead, you can use the TIME TRAVEL feature of Delta Lake to query previous versions of the table. You can use the VERSION AS OF or TIMESTAMP AS OF clauses in your SQL queries to access historical data.
Example:

SELECT * FROM my_table VERSION AS OF 10

Since the tables are streaming, simply deleting records and restarting the pipeline will not repopulate the deleted records. Instead, you need to perform a full refresh of the pipeline.
To do a full refresh, you can use the "Full Refresh all" option in the DLT pipeline UI. This will recompute and backfill all tables in the pipeline.
Alternatively, you can use the "Select Table for Refresh" option to refresh only specific tables, such as your Silver tables.