Your third sentence is grammatically correct, but I'm assuming it doesn't have your intended meaning. You probably mean "We won't be able to get an opportunity like this again." Because you're talking about the future, if you use the present tense "can't" ("cannot"), the "can't" doesn't refer to the future but to right now. Specifically, in this case, it changes the meaning of "can't" from the usual meaning "not able to" to a more hyperbolic meaning "it would have grave consequences". That is, "If I want X, I can't do/have Y."
"I can't give that guy my phone number." (because he seems bad and might track me down and hurt me)
"I can't give up." (because then I'd be a quitter)
"I can't say no to ice cream." (because I love eating it, so I'm not going to say no even though I could)
vs.
"I can't tie my shoes." (because I don't know how, I literally don't have the ability)
EX1 "I can't let my daughter go to that party on Saturday."
EX2 "I won't let me daughter go to that party on Saturday."
EX1 means if the parent let's the daughter go to the party, something bad will probably happen, and the parent doesn't want to feel responsible. It basically means by letting her go, she would be a bad parent. eg. "If I want to be a proper parent (in general), I can't let my daughter do these kinds of things."
EX2 means when Saturday comes, the daughter will not be allowed to go (by the parent) because "won't" is future tense, she is saying something that she will do (or not do in this case) in the future.
So, using "can't" in your example means something like, "If we get an opportunity like this again, it would be devastating." Opportunities are usually good, so the listener would probably understand that's not the intended meaning. However, a speaker could mean don't want any more opportunities because they (we) keep messing them up and it's becoming stressful.
So you want to use,
"We won't get an..." or "We won't have an..." or "We won't be able to get an..."