The most appropriate transition word to connect the two sentences is "however."
The revised connection would be: "I wanted to go to the grocery store with my mom; however, I had homework to do first."
This implies that despite wanting to go, there was an obstacle (the homework) that needed to be addressed first.