Fair question! Different folks get different things out of it. Personally, I got into it a few years ago since I have some friends who are into it. It drew me in with all the spectacle, and kept me in with how compelling the long-term storytelling can be.

Lots of people compare wrestling to soap operas, with the overdramatic acting and the constant, several-times-a-week frequency of shows, but really the closest comparison I'd have is something like the current Marvel movie franchise - a silly, bombastic thing that somehow winds up being surprisingly emotionally effective (at times). Of course, much like how there are a lot of bad superhero movies, there is a lot of bad wrestling, but the good stuff can be really good.

Not a wrestling fan but this short documentary made me understand the appeal

https://youtu.be/rnvSs3HEz2o