On my surfboards, when the fad was on pointed tips, I just sanded the tip 1-2cm to round it...
Otherwise, on my SUPs I use some layers of electric tape on the tip, mostly to protect the board, so that I can lay it carelessly on the road upside down. but it hits you a bit less harder too when you meet the board.
I apply ~ 4" strips of tape longitudinally: apply the first inch without stretching, stretch around the rail, finish without stretch on the last inch. Apply as many layers as you want. I apply also cross-strips along the rail line underneath.
I saw some people dipping the tip in "liquid rubber" paints too, used to create grips on hand tooling, like
plastidip.com/our-products/plasti-dip/ (Hey DJ, look! it even comes in yellow :-) )