John Barrowman, who recently opened up about the struggles he endured following an X-rated scandal, knew his husband was the one the minute he saw him