Looks pretty good to me.
Yes, you can trash a bunch of data with the click of a button.
But you can do that, anyway, without CASCADE DELETE.
Seems a specious argument, to me, by insecure coders.
An optimist sees the glass as half full.
A pessimist sees the glass as half empty.
A realist drinks it no matter how much there is.