This doesn't follow. There is no way to amend the Constitution by a national popular vote so the opinion of the majority of Americans is irrelevant to the question of any Amendment's passage.
A more likely reason such an Amendment wouldn't exist is that a majority of states favor the status quo, because most states are small and benefit from their current outsized representation in government.
Source: Article V
Edit: Corrected 3/4 -> 2/3
Edit2: I stand corrected. The Bayh-Celler proposal was passed by the House and filibustered in the Senate in 1970.
https://en.wikipedia.org/wiki/Electoral_College_abolition_am...
I believe this is factually incorrect. I'll offer Article V of the Constitution as my citation. Do you have a contrary citation to support this claim?
The major geographic divide in US politics is urban vs rural, not state vs state