Console app registered via AddProject does not execute Main() - Aspire 9.5.0 and .NET 10 RC1

### Is there an existing issue for this?

- [x] I have searched the existing issues

### Is your feature request related to a problem? Please describe the problem.

When adding a console application project to Aspire AppHost using AddProject, only projects with execute as expected. For projects with other SDK types, the process starts but the Main method is not called.

### Describe the solution you'd like

What I'm trying to do now is to run a one-off type migrator inside Aspire that uses a tool like DbUp to migrate the database based on SQL scripts to a PostgreSQL or any SQL databases.

### Additional context

1. Create a new console application project with .
2. Register with AddProject in AppHost.
3. Run Aspire AppHost and observe Main is not called.