X.com does not allow downloading videos without credentials anymore.
Use the option --cookies-from-browser <browser>, which extracts cookies from the browser session.
yt-dlp --cookies-from-browser firefox https://twitter.com/sovietvisuals/status/1715204231383093750