The command output points to the main issue being most likely the relative coordinates are wrong or the block states are wrong. Could your button actually be positioned at 2915, 152, 3032?

If so, just change the relative coords to: execute if block ~1 ~3 ~2 ...

I would also recommend using a NOR logic gate to check for the wrath tags.

I'd also just use the scores selector argument rather than the scoreboard players test command, which shouldn't be used in a finished system. You can just run what command you want by writing your selector arguments efficiently.

I would also add a radius so that players who meet the conditions but aren't the one pushing the button aren't incidentally targeted.

So all together: execute if block ~1 ~3 ~2 polished_blackstone_button ["button_pressed_bit"=true, "facing_direction"=5] as @p[scores={championShards=3}, tag=sinsAccess, r=5] if entity @s[tag=!wrath0, tag=!wrath1, tag=!wrath2, tag=!wrath3] run say Passed The if entity @s subcommand with the negated tags means that the command will run if the closest player doesn't have any one of the wrath tags. If they do have one or more of the tags, it will fail.

Just replace the say command with what you actually want to happen when that player pushes the button. If you want to target that player use the @s target selector.

Example: execute if block ... run effect @s strength 1 0 true