Johnson received the Razzie Award for Worst Actress in 2024 for her role in box office flop Madame Web