STYLE enable pylint: use-implicit-booleaness-not-comparison
Issue #48855. This PR enables pylint type "C" warning: `use-implicit-booleaness-not-comparison`
- [x] All [code checks passed](https://pandas.pydata.org/pandas-docs/dev/development/contributing_codebase.html#pre-commit).

Note:  Pylint at the moment raises the following error on clean main branch
```
************* Module pandas._libs.tslibs
pandas/_libs/tslibs/__init__.py:38:0: W0406: Module import itself (import-self)
```
Thanks @natmokval for working on this one

Are we sure this one's safe? E.g.
```python
a: list | None

a = None

if a == []:
    print('here')
```
doesn't print anything, but changing it to
```python
a: list | None

a = None

if not a:
    print('here')
```
prints `'here'`

Perhaps we should keep this one turned off, just like `use-implicit-booleaness-not-len`? Thanks, @MarcoGorelli,  you are right. I checked the behavior only in a subset of the cases. It is cleaner to keep this check turned off. cool, thanks - closing for now then, and sorry that you already did work on this!