The crux of this story was mentioned in Adi Parva of Mahabharata.
Sukra then answered, 'I never speak an untruth. Even now, O king, art
thou attacked by decrepitude. But if thou likest, thou art competent
to transfer this thy decrepitude to another.'
Yayati said, 'O Brahmana, let it be commanded by thee that that son of
mine who giveth me his ...
Mahabharata, in which the snake sacrifice was mentioned first, did not describe anything about Agni cursing Veda mantras to become ineffective.
The following is the extract from Mahabharata, where the final part of the snake sacrifice was described.
"Sauti said, 'Listen now to another very wonderful incident in
connection with Astika. When king ...
There was no mention of Agni getting cursed by Bhrigu in Rig Veda. Agni used to consume everything even before that.
Rig Veda I.98.2 eulogises Agni as Vaiśvānara
Present in heaven, in earth, all-present Agni,—all plants that grow on
ground hath he pervaded. May Agni, may Vaiśvānara with vigour,
present, preserve us day and night from foemen.