It is a common issue to find the NTFS drive won't mount after upgrading macOS, because the preinstalled NTFS drive for Mac haven't updated to be compatible with the latest OS.
When you upgrade macOS and use an NTFS drive for Mac, you should also update the NTFS driver to support the updated OS, otherwise, you may find the NTFS for Mac driver not working on Sonoma or earlier macOS. You should check whether there is an update for the preinstalled NTFS for Mac driver, if not, you can try other NTFS for Mac tools such as iBoysoft NTFS for Mac, which always keeps updated with the latest macOS.