The main issue is that you need to move both joysticks around counter-clockwise together while also keeping your right stick still inside the sweet-spot. Once you have found it, you then need to turn the entire lock around counter-clockwise using the left stick. Once you find the sweet spot using the right stick, the small circle will turn gold and vibrate. Somewhere inside of the circle is the sweet-spot you need to find with another smaller circle. When picking a lock, a lock in the shape of a circle shows up on the screen. In fact, it’s almost damn near impossible.
Although, it is very complicated to pick locks in the console version of this game. You will run into many locked chests in the world with great treasures inside. Picking locks is also a very useful skill to have in this game. Usually, that would be fine, except the way they tried to port it over almost completely breaks lockpicking. It’s clear to me that lockpicking in Kingdom Come: Deliverance was not really made for consoles and was optimized for PC instead.