does not work all that will happen is steam will download the mods again! you have to manually unsubscribed to each mod which is real pain if you have hundreds / thousands of subscribed workshop items
would be nice if they had game setting to disable all mods that way you can play with mods and without mods without to remove them by unsubscribing or by disabling each individially both a real pain