Read "ORM-level “delete” cascade vs. FOREIGN KEY level “ON DELETE” cascade" note in https://docs.sqlalchemy.org/en/13/orm/cascades.html#delete for the explanation.

TLDR: without this parameter, instead of a fast DB-level cascade trigger, a slow ORM-level cascade takes place