Update apply.py assertion message
Improved assertion message for possible duplicate column names

- [ ] closes #55964 

Thanks for the PR, but as labeled in the issue this needs more discussion before proceeding - this code path may need a larger update than updating the message.

Closing as this issue needs more discussion, but happy to have your contributions towards issues labeled "good first issue"