It would help to know what Operating System and Shell you have.
Many versions of "ping" default to "continuous ping" and never finish.
In my version the parameter "-n 3" will try three times, yours may be different.
Shell code is for most Bourne-like shells such as: sh, ksh, bash and Posix. Some would replace "cat" with an inward redirect if that shell will allow it.
cat link.csv|awk -F, '{print $1,$2}'|while read url title
do
echo "Pinging ${title}"
ping "${url}" -n 3
done