Low left will bring you too much up-table, which is where you ended up. Just a bit of draw will do ya. Look at your diagram and draw the angle to about the middle diamond on the rail between the 9 and the side pocket, that's about your target, hit that and bounce out a few feet. Really any place between the side pocket and the 9 will be OK , depends on the speed you hit. If you hit harder but go too high near the 9, your cueball can hit the 9 and bring it out for a shot (if you are a bit lucky that is), so really the only way to really mess up is hit it too soft and land on the 9 without moving it much.
From where you were ending up, it sounds like you were trying to draw/spin it without going to the second rail, just straight up-table is that right? That shot will get you going at the 9 more often than, you can even scratch in the corner by the 9 that way. Less spin and draw, hit almost anywhere in a 2 diamond range on long rail near the 9, bounce over to other side for the 9.
Excuse the crude lines LOL