I also encountered similar charging issues after my upgrade to Sonoma. The suggestion to reset the SCM also worked for me. Give that a try if you're still having issues charging over USB-C.