Nuxt content ignores cdnURL environment variable

Environment

Operating System: Darwin
Node Version: v20.18.0
Nuxt Version: 3.13.2
CLI Version: 3.15.0
Nitro Version: 2.9.7
Package Manager: npm@10.8.2
Builder: -
User Config: default
Runtime Modules: @nuxtjs/tailwindcss@6.12.2, @nuxt/content@2.13.4
Build Modules: -

Reproduction

This is the code deployed to AWS as described. The issue does not show itself when running locally.

https://github.com/tkgregory/bannerflex.git

Describe the bug

Nuxt includes a cdnURL configuration option to specify "An absolute URL to serve the public folder from (production-only)."

I don't think this option is respected in the Nuxt Content module.

Environment

I am deploying to AWS Lambda using the aws_lambda Nitro preset.

Lambda handles calls to / (my app has a single page) — contents of .output/server
Everything else served from /static/ — contents of .output/public.

My lambda function has the environment variable: NUXT_APP_CDN_URL: https://d13yx967ab4do4.cloudfront.net/static/

Issue

My application is a single Vue component which reads a .yml file via Nuxt Content (view source).

<script lang="ts" setup>
const pricing = await queryContent('/pricing').findOne()
</script>

<template>
  <main>
    <p>Found {{ pricing.prices.length }} items in /pricing</p>
  </main>
</template>

Access the deployed application to see the following errors yourself here here.

Viewing source shows resources served from /static/ e.g. JS.

<link rel="prefetch" as="script" crossorigin href="https://d13yx967ab4do4.cloudfront.net/static/_nuxt/SPCSjI8F.js">

This makes me believe NUXT_APP_CDN_URL has taken effect for core application.

But Network tab shows 404 error fetching content:

https://d13yx967ab4do4.cloudfront.net/api/_content/query/BeNxk91izP.1730146068844.json?_params=%7B%22first%22:true,%22where%22:%5B%7B%22_path%22:%22%2Fpricing%22%7D%5D,%22sort%22:%5B%7B%22_stem%22:1,%22$numeric%22:true%7D%5D%7D

Error response body is {"message":"Not Found"}

Hence page fails to load and we see blank screen.

Expectation

I expect the page to load OK.

I can see this JSON file is available https://d13yx967ab4do4.cloudfront.net/static/api/_content/cache.1730146068844.json.

I may be doing something wrong here, but my suspicion is Nuxt Content is looking for the JSON file in the wrong location.

What else did I try?

run locally via nuxt dev OK
build with default nitro preset and run using node .output/server/index.mjs OK
include contents of .output/public with Lambda in case Nuxt Content is look for files locally (made no difference)
render a markdown file via <ContentDoc> OK

Additional context

No response

Logs

No response

nuxt / content