Draft: Bump rubocop gem to 1.65.1
What does this MR do and why?
Bump Rubocop gem to [1.65.1](https://github.com/rubocop/rubocop/blob/master/CHANGELOG.md#1651-2024-08-01 to unblock gitlab-org/gitlab-services/version.gitlab.com!154 (closed).
Bump Rubocop gem to [1.65.1](https://github.com/rubocop/rubocop/blob/master/CHANGELOG.md#1651-2024-08-01 to unblock gitlab-org/gitlab-services/version.gitlab.com!154 (closed).