This is a common issue... super convenient for a vehicle that needs the oil checked frequently. The problem usually has less to do with the cable and more to do with either, the spring wearing out that makes the latch "pop" or a misalignment of the latch to the hood catch. Typically, you can have a helper pull the hood up while you have the latch handle pulled.

To solve this... I lube the latch components and move the latch assembly (by loosening it's bolts) until I find a position where the hood "pops" again. Seems like I have to adjust the latch every 6 months or so...

In the past I also installed a spring to help "pop" the hood. I got the idea from the Jeep JK wranglers. It worked well but I unintentionally smashed the spring a while back and haven't installed another one.