That's inherently the biggest problem I'd say. Football fans are steeped in a certain culture, different from fans of other sports. This extends to when a scoring event occurs. Goals are so rare in a game (relatively) that naturally they are celebrated very hard.
The deflating feeling after a goal is overturned is not worth the introduction of the technology and any perceived increase in decision 'consistency'. Fans care far, far more about the natural flow amd habits of the game as opposed to a ref getting every single decision right. You are blind robbing the fans of precious moments of euphoria throughout a match. If the officials on the ground cannot do their job by picking something up then improve THEM, not take this piss weak option of trying to get technology to do their job for them.