MacBook Air hanging/freezing repeatedly

Most likely an incompatible third-party extension. See if the problem is present when you boot in safe mode, which disables 3rd party extensions and performs some system cleanup.

Start up your Mac in safe mode - Apple Support

Yes. Run an EtreCheck report and post it here so that we can assist you with what may be the culprit(s) that is causing this issue. Without one, all we know is that you have a 15" MacBook Air, running macOS Tahoe that hangs/freezes repeatedly.

Ref: https://discussions.apple.com/docs/DOC-250000632

Using Automatic Computer Sleep Mode has been causing that problem for sometime now.

As a test:

Disable the Screensaver.

It does nothing buy waste valuable Resources.

Turn On "Prevent automatic sleeping when display is off"

Set "Turn display off when inactive" to 5 or 10 minutes

Leave the MacBook Air On and only allow the display(s) to turn Off

Do not manually Sleep from the Apple Drop Down menu

Shut Down when your not using for a day or more

Note: Your Energy and Lock Screen setting will look slightly different.

Sorry all that I have at this time are examples from a desktop.

1) The early versions of Tahoe were buggy and you should update to latest 26.2 version.

see > What's new in the updates for macOS Tahoe - Apple Support

2) Then check all of your third-party App's to make sure that they are up to date.

Ambrosia, Wacom, Adobe, OnePassword, etc. etc. etc....

3) You should also consider using Time Machine to protect your data.

see > Back up your Mac with Time Machine - Apple Support

Per chance are you actively using a VPN whenever you are connecting your Mac for Internet access?

From your EtreCheck report, the crash is specifically tied to Apple’s Software Update process (`softwareupdated` / Software Update.app), and it’s happening a lot (48 times since Dec 20). The key clue is `libsystem_c.dylib: abort() called`—that usually means the process hit a condition it considers unrecoverable and intentionally terminated itself. In practice, this is most often triggered by a corrupt update cache/catalog, a stuck/failed update attempt, a device management/profile restriction, or occasionally network/VPN/proxy filtering interfering with Apple’s update services.

Here are a few suggestions, I would like for you to try:

• First, ensure your Mac has at least 20–30 GB free storage space. From the report, it appears that it does.
• Next, verify that the Mac's Date & Time is both set automatically, and is correct.
• Finally, temporarily disable/uninstall anything that intercepts traffic (VPN, “security” network filters, ad blockers with system extensions), and then, try System Settings → General → Software Update again.

If it’s still looping, I’d reset the Software Update caches and try again:

1. Restart the Mac once more.
2. Boot to Safe Mode. Then restart normally.
3. In Terminal, run: softwareupdate --list and note whether it errors immediately or can fetch a catalog.

If crashes continue after cache/profile/network checks, the cleanest “final” fix is an in-place macOS reinstall from Recovery (this keeps data but refreshes system components that Software Update relies on).