How Effective were Spears Against Cavalry?

[Domen]

after noting that the Romans did not flinch

Nope...

After noting that each cohort-square of the Roman hollow square formation was ca. 25 ranks deep...

And regarding the available Roman accounts of the battle of Carrhae - Cassius Dio actually writes about cataphracts charging and smashing the ranks of Roman infantry.