You are constantly getting stronger if you are casual leveling, because gear from new quests end up always better than what you had before.
But, if you have a well-geared character from previous expansion, you do get weaker as new gear is often worse than yours, and your gear scaling gets worse as you level up.
It’s not much different from what it was before scaling, except that you could outlevel some areas before, and you’d only feel weaker when you moved to new areas.
IMO, the benefits of scaling far outweight its drawbacks. Whole world to play and never feeling really safe are awesome for the long term of the game. In pre-Legion expansions, 80% or so of the area became useless once you reached max level.