What do I need to transfer photos on a cf card in my camera to my iPad pro

1. A USB CF Card reader.
2. A cable / adapter to connect the card reader to the iPad.
3. Maybe, a powered USB hub to power the card reader.

Is the cord used for charging phone the same to transfer pictures?

Is the cord used for charging the same for transering pictures from phone to computer?

Yes. If connecting to a computer, you use the charging cable that came with the iPad to do so.