It is possible to be involved in something for various reasons, but it does not mean that one should willingly forego a benefit. "In it for the money" implies that the primary motivation is high pay, whereas "not in it for the money" indicates a strong preference for the type of work and a willingness to accept lower pay if market rates were to decrease.