DOC for refactored compression (GH14576) + BUG: bz2-compressed URL with C engine (GH14874)
Follow up on https://github.com/pandas-dev/pandas/pull/14576, which refactored compression code to expand URL support.

Fixes up some small remaining issues and adds a what's new entry.

- [x] Closes #14874
