Table alias ignored for columns specified in INSERT statement in SQL Server
List of column names in this place is list of names in #DEMO1 table therefore qualifiers doesn't have any meaning and most likely are just ignored.
It is interesting why it doesn't rise syntax error, either way if you would want to use columns names as a.a.a.value1 then you would have to put name in [] or "".