An aspiring page is a page that does not yet exist, but is already linked to somewhere in the space.
Aspiring pages appear in the Page Picker (with a Create chip) as well as in auto complete when creating Link.
Every [[link]] to a non-existent page produces an Tag/aspiring-page object in the Object Index, so you can query them to audit broken or forward-references:
${query[[
from t = index.aspiringPages()
select { target = t.name, linkedFrom = t.page }
]]}
In this query, t.name is the link target (the page that does not yet exist). t.page is where the link lives (the source page). Filter on t.page to scope results to your own content.
Triage guidance: