Prohibit `nil` namespace type

Once we have no more nil type namespaces in the DB #341069 (closed) or in specs #341447 (closed), we can start to prohibit nil type in the DB at all.

MR merge order:

• !74592 (merged)
• !74152 (merged)
• !73495 (merged)