Update typing to follow pyright

[pierceroberts]

Based on the work in this PR: #4425
It was determined that we make smaller PR's to update the typing to follow the pyright instead of mypy.
These smaller PR's will work towards the goal of eliminating mypy and switching permanently to pyright.
Objectives:

1. Fix typing issues from the exclude list in follow-up small PRs
   a. Based on more restrictions we can set those and then clean them up in small prs.
2. When the fix list for at least opentelemetry-api and opentelemetry-sdk/resources is done, we remove mypy from CI.
   a. Once the small PRs are merged we can remove the ci stuff.