Suggestion to have deleting projects delete both unassigned and assigned tasks unique to the project.
Hey @Rocky_5, here is a great post about the best practices when deleting a project that might be helpful.
If you also wish to delete assigned tasks you can for example use the multi-select in list view to unassign them first.