@Mandy276 Superhost status is something that is earned or lost according to a set of statistics which is monitored by a computer algorithm- it isn't something Airbnb manually decides to confer or remove. It's based on the average star ratings, whether a host responds to guest messages within 24 hours, the % of booking requests they accept, whether or not they have cancelled a confirmed guest reservation, and the number of bookings or days per year a host gets.
If a guest has a serious complaint about a listing, Airbb will investigate, most likely suspending the host's listing while they do so, and if the complaint is egregeous enough, that host may be removed from the platform.
But otherwise, a guest's experience with a host or a listing wouldn't affect Superhost status unless your star rating brought their rating average down to the point that fell below the minimum.
As for your review not appearing, has the 14 day review period ended? If not, it will appear after 14 days whether the host left a review for you or not. Also, if the host has a lot of reviews, you may have to scroll through them to find yours- they are not in chronological order of when a guest stayed.