This is nonsense and a good hint is that you are putting words in the mouths of others and then attacking them for those words.
I've never taken a database course but I had nearly 20 years of database design in industry for mid-level systems. I have read some database books written by academics along the way. The claim that they "preach normalization at (sic) an absolute goal" is plain wrong in my experience.
The academic books I've read describe multiple normal forms. I don't recall ever seeing one singled as superior to all the others, different normal forms reflect different (generally theoretical) perspectives on data and the relational calculus. Not surprising, I think, and I am confident that being informed about different perspectives has helped me design systems.
Database design requires a designer to balance various factors, including where the data comes from, how it is to be maintained, and how it is to be used (including performance of queries). I have no idea which of all the tables I've designed and run in production may or may not be normalized by any of the multiple normalizations that have been described. But I read those books in order to improve my skills and it was time well spent.
Tom