I have not been able to make the cascade work in SQLite.
What I do is to add an extra step to delete the Links that are related to the deleted Collection.
As a side note: I am sure that this is not a failure of SQLite, meaning that there may be a bug in Wappler.