DEPR: Deprecate Series/Dataframe.to_dense/to_sparse
- [x] closes  #26557 
- [x] passes `git diff upstream/master -u -- "*.py" | flake8 --diff`
- [x] add whatsnew entry
- [x] add tests

Marks the methods mentioned in #26557 as deprecated, with proper messages.