The last game I played was Automobilista 2, the main character is just an ordinary human that’s good at driving cars

So in other words yes, he will drift around all the monsters, get all of the Great Ones to take an interest in racing, and thereby save Yharnam as depicted in the canon sequel Nightmare Kart