The country star remembered James’ generosity and songwriting together, including their Grammy-winning hit "Jesus Take the Wheel"