It's give and take. Maybe not "do what you love no matter what" but "try and do something you at least like" is still good advice. If you force yourself to do something you hate just because you think you'll make money not only will you spend your life miserable, but you also likely won't be terribly successful because it's hard not to burn out.

Said differently, making money matters and should be considered, but it should not override all other factors when choosing a career.