Switch positional logical-date-or-run-id CLI argument to a flag?

### Body Raised during review of #46407. We introduced `logical_date_or_run_id` back in 2.2 when we started enforcing the DR-TI relationship so people can select a TI with run_id instead of execution_date. The argument was implemented as a “smart” positional argument because we needed to maintain backward compatibility of the CLI. With 3.0, however, it is possible to get rid of the magic and require the user to pass in a named argument instead, so instead of ``` $ airflow tasks run <dag_id> <task_id> <logical_date_or_run_id> ``` the user must write ``` $ airflow tasks run <dag_id> <task_id> --run-id <run_id> ``` or ``` $ airflow tasks run <dag_id> <task_id> --logical-date <logical_date> ``` This feels like an improvement in a vacuum, but is it worthwhile as a breaking change? ### Committer - [x] I acknowledge that I am a maintainer/committer of the Apache Airflow project.