The flag essentially deletes the user's profile folder and all objects contained therein when deleting a user via the DELETE USER statement.
DELETE USER "Test" CASCADE PROFILES;
The flag is the equivalent of this feature in Strategy Command Manager:
