Will you be comfortable paying for the Reno? Adding a new header is a 3-4 man job, ie the cost will be large. In the end, totally worth it but you have to eat the cost.

I got a quote to remove the post and add a 24ft beam. I am ok with that option ( not super sure if I want to spend that kind of money for beam addition). Though I want to know if I keep the pillar how bad will it look? Is it ok to have it

A talented designer could work around a pillar if cost was an issue. Here is an example of one I did last year.

Would suggest you increase the width between the cabinetry and refrigerator from 3'-0" to 4'-0". 3'-0" just isn't wide enough to maneuver in a kitchen.