The ALMaQUEST Survey IX: The nature of the resolved star forming main sequence