Gnome doesn't start, no gdm.service, broken software databases

[Yochanan]

Manjaro boots into tty1, graphics disabled

Did you happen to remove orphan packages after updating? If so, you may have accidentally removed gdm (GNOME Display Manager). If so, you can install it and restart the service from a TTY: sudo pacman -S gdm systemctl restart gdm

@mipcer

the 6.0.12 kernel

That kernel is EOL (End Of Life) and is no longer in the repos. Use Manjaro Settings Manager or MHWD to install a different kernel, reboot then remove 6.0.