Updating Manjaro Uranos gives "No Source" error and black screen

This kernel is EOL (end-of-life, dead, gone, unsupported).
Please (install and) boot into a supported kernel (such as 6.1 LTS or 6.6 LTS) and remove 6.5. ex:

sudo mhwd-kernel -r linux65

PS.

Just in case you need it here is a guide for tty, chroot, etc.