The problem was in raspi-config, I thought I've enabled the camera through config.txt, but I've not. so when I've got into the interfaces tab and enabled the camera, everything worked perfectly. Thank you guys for help :)
According to the log, the camera connects to the bus and then immediately disconnects. I'd say a power issue is most likely.
Disconnect all USB devices and plug just the webcam, see if it stays connected in that case. Try shorter cables to supply power to the Pi, or a different power supply.
If you have a multimeter, check the voltage on the 5V pin, and, if ...
I got the same problem when using raspberrypi camera the problem was that it outputs NV12 format not RGB
you can use this code to test your camera https://github.com/JetsonHacksNano/CSI-Camera
or just add "format=(string)NV12" as a parameter of cv2.VideoCapture