Templates 9.0 follow up work

[radical]

Once https://github.com/dotnet/aspire/pull/6058 is merged:

• [ ] unsupported hosts - vs version Does this need to be bumped higher? Are we doing any testing of Aspire 9 with VS 17.10 or 17.11? https://github.com/dotnet/aspire/pull/6058#discussion_r1784890643
• [ ] Update Microsoft.Extensions.HttpResilience version in the net9 template to net9 nuget.
• [ ] Check if the Web template needs any updates
• [x] Make sure https://aka.ms/dotnet/aspire/third-party-notices is valid, used in the templates
• [x] Update app host templates to use WaitFor where applicable
• [x] Update Service Defaults template to configure tracing for an activity source with the application name
• [ ] #4206
• [ ] [tests] Add new-and-build tests for servicedefaults, and apphost templates

cc @DamianEdwards @joperezr

[DamianEdwards]

I ensured https://aka.ms/dotnet/aspire/third-party-notices works