Do you remember Stanley Tweedle from the sci-fi series "Lexx"?

if not, let me summarize him. He works a cubicle job earning only enough to get by, sleeps maximum quota and does the minimum to not get fired.
Eventually aliens show up and eat his planet. He escapes by fluke of being with the other good guys, and he's a pilot and they can't fly their ship, so they keep him.
After that, he spends the rest of season 1 shirking responsibilities, napping while on guard duty, trying to get into Zev's pants (but by peeping on her showering instead of bothering to hit on her), and many more. He is, effectively, the least motivated character I've seen in any work of fiction.
I found myself often wishing aliens got him so I wouldn't have to put up with him
My thought: The plot you have chosen appears to be leading you down a similar path. This is salvageable, but let me answer that the long way.
tng: Lt Barclay

They introduced him as this blathering inept, socially awkward engineer but he was more of a laughing stock.
Later on he cleaned up. He was still a blathering, inept, socially awkward engineer but he was suddenly freaking smart*.
What happened? Writers watching him getting panned realized he had to win hearts. And apathy wasn;t going to win hearts, so they made him good at something. They picked a new areas of engineering no other character could excel at and gave them to him. In the turn of a season they had a cult hit.
Why? What changed the viewers? Easy. Suddenly we were all Barclay. Scraping to get by, awkward person out. Not invited to that party and passed on the promotion. But having that one skill that made us special and wishing the world would recognize it.
Therein is my recommendation
If your character is Luke Skywalker, fixes droids and drinks blue milk in some backwater -> have a mysterious guy in robes tell him you are the one
If your character is Rand Al'Thor and his only want in life is farming and shearing sheep -> make him deadly with the quarter staff (Actually, I stole this one for Tia because she's rather passive in her 3rd chapter). Your logical option here is the pistol. Make him a crack shot with it even if he is terrified while in action.
Recommended reading: One Punch Man (In your case, "one shot man")
Give him at least one thing he's good at so the reader can latch onto it and identify with the struggle, and you'll be fine