Yes it´s totally different in tone and atmosphere. Even when you played the final Game before the Demo is still worth playing.
Played both and deff thought the demo was superior imo.