As far as the ranged/melee stuff, I'm not really sure what this article is trying to say. It definitely is more confusing than previous statements.
Before this article came out, this is how things had been clarified:
There are two types of weapon attacks:
1) Melee weapon attack
2) Ranged weapon attack
The way those statement are parsed is that they are "weapon attacks" that are either "melee" or "ranged." Nothing in those phrases directly references the nature of the weapon itself, because they aren't referring to weapons--the are referring to types of attacks. This is why a monk makes melee "weapon attacks", even though fists aren't considered weapons, because hitting something up close without using magic (which would be a melee "spell attack") is always a "weapon attack."
There are also two types of weapons.
1) Melee-weapons
2) Ranged-weapons
You can make a "melee-weapon attack", which is an attack with a melee-weapon.
So, "melee weapon attack" means a weapon attack made in melee. A "melee-weapon attack" means an attack made with a melee-weapon.
This is how it has been explained by Jeremy Crawford in the past.
The question is if he is still going with that interpretation, or doing something different with this Sage Advice--and if he is doing something different, what is it?