It is just a public statement of support. There are only consequences to the extent that people care about/respect the opinion and judgment of the person giving the endorsement.

In this case, it’s valuable to RFK Jr in so far as individuals listening to Joe Rogan either think Joe has good insights into who should be president, or just want to be like him and will vote the way they think he will vote