[EDIT] fixed and out on all the mirrors! Thanks for your patience!
The /latest/ packages repo, for amd64 FreeBSD 15.0-RELEASE, has invalid metadata.
TLDR if you see this error during `pkg update -r FreeBSD-ports`
pkg: sqlite error while executing grmbl in file update.c:171: NOT NULL constraint failed: packages.path
Then go for a walk/pizza/fresh air, and check again when you're back.
Baptiste & Antoine have fixed it in the main package builder, and it's trickling out to mirrors atm.
Technical details in https://github.com/freebsd/pkg/issues/2575
I'll also update this toot once it's sorted!