Why Content Path cannot be used to sort a view?
Node path is not a field from DB table. It is calculated dynamically.

In views you can only sort if a sorting can be applied to the underlying SQL query.