Physical conditions of the molecular gas in the SMC's star forming region NGC 346