Auto schedule tasks with over-allocated resources

I need to manage a project using the Project tool. I can’t seem to get it to automatically adjust the resources assigned to tasks when tasks with the same resources overlap. Here’s a simplified example:

Project Characteristics:

• No set end date -> The goal is to define the end date based on the total task duration (within certain limits). We have information on the hours each task should take and the start date. Based on these criteria and the resources assigned to each task, we’ll determine the project’s end date and adjust accordingly.
• 2 tasks (simplified example)
• 2 resources: “Player 1” and “Player 2,” both dedicated 100% to the project.
  • Schedule: Monday to Thursday, 8:00 AM to 6:00 PM, and Friday, 8:00 AM to 2:30 PM. Spanish public holidays included.
  • The task start dates are fixed.

Task Details:Task 1 - "Breathe"

• Duration: 100 hours
• Start date: 12/02/2024 (a "Must Start On" constraint has been added)
• Assigned resources: Player 1 and Player 2
• Task configuration:
  • Duration: 6.25 days -> Estimated automatically by Project. I don’t have a days duration limitation, only by hours. The Estimated checkbox is also marked.
  • Schedule mode: Auto Scheduled
  • Resources: Player 1 (100% units) and Player 2 (100% units) -> This indicates that both resources can dedicate 100% of their time to the task, but if it overlaps with others, it should adjust automatically. In this simplified example, manual adjustments are possible, but this won’t be feasible in a real-world scenario with many tasks and resources.
  • Task type: Fixed units, and Effort-driven is marked -> The goal is to adjust as needed when resources are added or removed, changing only the task's end date and the hours allocated per resource, not the total hours.

Task 2 - "Complete Mission 1"

• Duration: 50 hours
• Start date: 12/02/2024 (a "Must Start On" constraint has been added)
• Predecessor: Task 1 ("Breathe") with a Start-to-Start dependency.
• Assigned resource: Player 1
• Task configuration:
  • Same as Task 1, except it has Task 1 as a predecessor.

The Issue:

Based on the setup, Tasks 1 and 2 will overlap. Both resources will dedicate 9 hours daily to each task, causing "Player 1" to work 9 hours on "Breathe" and 9 hours on "Complete Mission 1" simultaneously. This results in an 18-hour workday, exceeding their 9-hour limit.

Attempted Solution:

I tried to resolve the overlap by leveling resources through "Leveling Options" with the following configuration:

• Leveling calculations: Automatic
• Look for overallocations on a: Day-by-day basis
• Clear leveling values before leveling: Checked
• Level entire project: Checked
• Leveling order: Standard (no priorities assigned)
• Level only within available slack: Not checked
• Leveling can adjust individual assignments on a task: Checked
• Leveling can create splits in remaining work: Not checked
• Level resources with the proposed booking type: Checked
• Level manually scheduled tasks: Checked (even though all tasks are auto-scheduled)

Desired Outcome:

I need Project to automatically adjust the resource's available time (9 hours) between the daily tasks (in this case, two). It should delay the end dates and assign 4.5 hours to each task. This adjustment must be automatic because, in the real-world scenario, there are many tasks and resources in the project, making 100% manual adjustments unfeasible.

If anyone knows what I might be doing wrong or if my approach is flawed, I’d greatly appreciate the help.