Can the csa offer free paternity tests when there is no possibility of me being able to pay for one?

Depends on the local agency. Ask them. If its an issue of legal action, the court may pay for it.