Late update as I've been extremely busy and stressed out in general with the move. I've finally got some downtime to write this.
First, thank you everyone for responding. I consider myself lucky to have stumbled across this forum in general prior to the move as it helped me prepare and be a lot more confident in crossing the border.
An update on what happened and what I did in case anyone else is in a similar situation. So, my husband and I drove from California all the way to Toronto in a Uhaul with most of our stuff. Prior to the drive, I read extensively about dual-intent and got mentally prepared. Researching dual intent helped prove to myself that what I was planning to do was perfectly legal and the only reason why I would be denied should be miscommunication or lack of evidence that my husband's entry was temporary. To prepare for the border crossing, I printed out my approval as a sponsor, several documents proving my husband still had ties in the US including lease documents, bank statements and other misc bills. I also printed out the page describing what dual intent was from the Canadian government website in case I had to argue with the guard what we were doing was legal.
After this, we drove all the way to detroit and entered via the detroit-windsor tunnel. We didn't really pick this location and it was just the most convenient port of entry for us. Before getting to the border, I briefed my husband quickly about what dual-intent was as well as what he needed to argue (that he is only going to enter as a temporary visitor and that he will leave at the end of his stay). After that, we got to the border and we had a pretty friendly chat with the border person (we might have lucked out here). The border person did question my husband, however my husband made it very clear that he was only coming as a visitor and that he would eventually return to the US once his visit was over. I think by the end of the conversation the guard was pretty convinced so we didn't end up needing any of the documents I had prepared and we were able to enter just fine.
All in all it was a stressful move but I think as long as you do the research, come well prepared and don't get a super unlucky with the border person, you should fare just fine.
I definitely recommend anyone who attempts this to fully read and understand the contents of this page:
https://www.canada.ca/en/immigration-refugees-citizenship/corporate/publications-manuals/operational-bulletins-manuals/temporary-residents/visitors/dual-intent-applicants.html.