I feel that it has become less useful since containerised tabs were introduced. One of the use cases for profiles were using a separate browsing profile.
Profiles should be easy to use, like any other application: When you logout of one profile and into another, everything changes.