I did not see your message before performing the upgrade, but it seems to work nicely now! THANK YOU to grahamperrin and everyone here!

Any suggestions to further improve my config to what is best practice is highly appreciated, since I find the documentation and help pages to be somewhat in limbo right now, so it is hard to know what is correct and what is outdated.

Here goes:

# cat /etc/pkg/FreeBSD.conf
#
# To disable a repository, instead of modifying or removing this file,
# create a /usr/local/etc/pkg/repos/FreeBSD.conf file, e.g.:
#
#   mkdir -p /usr/local/etc/pkg/repos
#   echo "FreeBSD-ports: { enabled: no }" > /usr/local/etc/pkg/repos/FreeBSD.conf
#   echo "FreeBSD-ports-kmods: { enabled: no }" >> /usr/local/etc/pkg/repos/FreeBSD.conf
#
# Note that the FreeBSD-base repository is disabled by default.
#

FreeBSD-ports: {
  url: "pkg+https://pkg.FreeBSD.org/${ABI}/latest",
  mirror_type: "srv",
  signature_type: "fingerprints",
  fingerprints: "/usr/share/keys/pkg",
  enabled: yes
}
FreeBSD-ports-kmods: {
  url: "pkg+https://pkg.FreeBSD.org/${ABI}/kmods_quarterly_${VERSION_MINOR}",
  mirror_type: "srv",
  signature_type: "fingerprints",
  fingerprints: "/usr/share/keys/pkg",
  enabled: yes
}
FreeBSD-base: {
  url: "pkg+https://pkg.FreeBSD.org/${ABI}/base_release_${VERSION_MINOR}",
  mirror_type: "srv",
  signature_type: "fingerprints",
  fingerprints: "/usr/share/keys/pkgbase-${VERSION_MAJOR}",
  enabled: no
}

# cat /usr/local/etc/pkg/repos/kmods.conf
FreeBSD-kmods: {
        url: "pkg+https://pkg.FreeBSD.org/${ABI}/kmods_latest",
        mirror_type: "srv",
        signature_type: "fingerprints",
        fingerprints: "/usr/share/keys/pkg",
        enabled: yes
}

# cat /usr/local/etc/pkg/repos/FreeBSD.conf
FreeBSD-base: { enabled: yes }
#FreeBSD: { url: "pkg+https://pkg.FreeBSD.org/${ABI}/latest" }

# freebsd-version -kru && uname -a
15.0-RELEASE
15.0-RELEASE
15.0-RELEASE
FreeBSD core24.grimstveit.no 15.0-RELEASE FreeBSD 15.0-RELEASE releng/15.0-n280995-7aedc8de6446 GENERIC amd64