Your libraries are synced onto your local drive.
On windows you can see the contents in C:> Username > AppData > Roaming > Adobe > Creative Cloud Libraries > LIBS > library number code > components
If you want them elsewhere you can copy them (don't move or your library will get in a knot)
If you just want to make a pattern available for future use in Photoshop you can right click it in the library then choose Create Pattern Preset. You can then delete from the library and it will be stored as one of your Photoshop presets
To save a brush for future use in Photoshop , outside the library - Select the brush tool and choose the brush from your library. Then go to brush presets panel and choose new brush preset.
For Patterns from Capture, right-click on them in the Libraries panel, and choose "Create Pattern Preset". For brushes, select the brush from the Libraries panel, and then in the Brush panel menu, choose "New Brush Preset".