It's possible that you may be referring to a custom mission or mod created by players, as Far Cry games often have a robust modding community.
However, as of my knowledge cutoff in September 2021, there is no official mission or scenario in Far Cry 6 involving a mission failure due to a shark attack.