So this is the epilogue to the journey, it takes a while to get the hang of.
Firstly in the main settings set the shooting to manual and difficulty to beginner.
Then you simply want to press LB and B for a lobbed shot. I found the best way to do this was to actually face downwards at the centre circle rather then straight at goal, like the video below
Obviously I got this by checking out the below video, the reason I'm making a separate solution is that after a long slog it was when trying from this area of the pitch that I came closest several times before eventually getting it to pop in.