Ok first off ball pythons do not like to be touched by us. He was not arching his back in pleasure, it was his muscles tensing up to something touching him.
Many BPs hiss. For most BPs it is a bluff hiss. They do it in hope of whatever just scared them will go away.
When mine hiss when I wake them up I pick them up (slowly and carefully) and hold them briefly. The interaction with you will build some trust that and help your BP identify you as something that will not hurt them. Again I recommend keeping it brief at first so you do not stress them out.
You BP will never "like" being picked up and held by you. But if you build trust over time and they figure out that you will not hurt them they will tolerate being held very well.