It can be profitable, but few are able to make that work. We'll need a lot more Lightning users before this can be a proper business model. People who run nodes today may be enthusiasts, but like other entrepreneurs they might simply be making a bet on the viability of their business in the future.